Share via

Excel , Data numen

rob bowers 21 Reputation points
2020-09-29T09:16:00.957+00:00

Hi, I downloaded the online shopping cart , from Data numen I’d like to add a column in the “inventory” as “stock” this will have all our stock quantities in, can we get it so when our customers add item/s to their cart it deducts from the inventory?thanks

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
0 comments
Accepted answer
  1. Emi Zhang-MSFT 23,906 Reputation points Microsoft Vendor
    2020-09-30T07:56:28.997+00:00

    Hi @rob bowers ,
    What is Data numen? What is online shopping cart?
    Do you mean you try to download data to Excel and want to add a new column to the Excel, create the relationship between the Data numen/online shopping cart and Excel?
    Could you provide more information or screenshots about this problem?

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. rob bowers 21 Reputation points
    2020-09-30T08:29:37.177+00:00

    I copied this from the web page hopefully it will help you understand more How does it work?

    As we have data validation on the field “ItemName”, customers can now pick an item from the drop down. So as they select an item, using Vlookup, the workbook identifies the corresponding Item description and per item price from the sheet “inventory”. This information is displayed on the sheet “Cart”. When the field “Quantity” is updated, the total price gets populated with correct values. To avoid fields showing “N/A” or “0”, we have added IF statements.

  2. rob bowers 21 Reputation points
    2020-09-30T08:48:18.6+00:00

    ![29335-1f0fb4d0-e1e0-4efe-823a-0aa44cf708ad.png][1]

    [1]: /api/attachments/29335-1f0fb4d0-e1e0-4efe-823a-0aa44cf708ad.png?platform=QnA How does it work?