Product CSV upload - Variant Inventory Quantity - does it relate to item stock qty or sku?

Highlighted
New Member
2 0 0

Hi,

I'm a little confused about how to enter the inventory quantity on the Product CSV to upload.

I have several items that use the same raw stock item, so a T-Shirt (SKU LL001) with 3 different designs. Each design is a different line on the CSV, but as they share the same SKU, should I input the inventory quantity as 10 on all 3 lines (on the basis I have 10 t-shirts in stock ready to print onto, not 10 of each design)?

If I then sell 1 of the designs, will all 3 t-shirt designs then have a corrected inventory of 9?

I hope this makes sense!?

Thanks in advance

0 Likes
Highlighted
Tourist
52 0 3

CSV is full of issues

 

I use API

 

Shoot me email I'll help

 

makkysolutionsltd@gmail.com

0 Likes
Highlighted
Shopify Partner
74 2 3

Hi

In terms of csv uploading you need to use the inventory csv import as you can no longer update inventory on the product csv upload: https://help.shopify.com/en/manual/products/inventory/inventory-csv

For your inventory management you would need to have a separate app for this as Shopify will not update the stock values this way. You would need to have an inventory system whereby your final product is built from another product and as this gets sold it updates all linked products. We can accommodate such a solution but if you are just starting you may try to manage it through csv till you feel the need to automate the process more.

Regards

Tom

Over 16 years experience in operating ecommerce businesses.
DM me on here or via message at Channelup
0 Likes