I have an inventory sheet that I need to be figured out. I know that outcome is needed, but I want someone to give me some better ideas on how to design and construct the sheet.
Attached is the sheet with some instructions.
The work is needed on the first 3 sheets, the last 4 sheets are here to provide you with the data needed.
The fields to fill with formulas are highlighted in yellow.
We sell on several websites, and on my sheets, A marketplace listing is called "Store SKU". Every Store SKU is mapped to an internal Item Number of our internal catalog, we do have a "MAPPING" that will tell you what is the item number for each store SKU.
Basically, this is an ordering sheet, that the buyer will make a note how much to order for a "Store SKU", i need the sheet to do the following jobs:
A) Import "warehouse" stock into "Working sheet" so the buyer can see if the item is available in any of our warehouses.
B) Generate an order to place from the vendor - but in this order, the item number have to be unique, meaning if the item number is ordered for a few different "Store SKU"s, it should only show once on the PO sheet, with the total QTY
C) Generate a "Shipment" in the shipment sheet, using the "Store SKU" or listing ID.
Let me know if you can work with these, and your cost would be - If we agree, I will provide you with more detailed instructions.
If you would like to give it a shot we can get into more details, so I can explain everything better.
Let me know your initial thoughts.
46 pekerja bebas membida secara purata $120 untuk pekerjaan ini
Hey, I can give you some better ideas on how to design and construct the sheet What is your Deadline?? Let's Talk upon your project Waiting for your response!!