show multiple quantites of item in stock?

We sell products at multiple locations. The item has the same price at each location, but different quantities on hand. Is there a particular header I should be using in my CSV to show which store has which quantity of the items? My current headers on the CSV are: categories, product_vendor_id (which should be the store number), product_code, product_name, price_value, and product_quantity.

For example:
Store 2 has 25 bottles of item 50707
Store 3 has 12 bottles of item 50707
Store 4 has 8 bottles of item 50707
Store 6 has 0 bottles of item 50707

Hi officemike,

Maybe you can do that with characteristics. And for each variant, in that case each store, a different quantity.

You can try:
product_vendor_id, product_code, product_name, price_value, product_quantity, product_type, store

2, 50707, item_name, price, 25, main, 2
2, 50707, item_name, price, 25, variant, 2
3, 50707, item_name, price, 12, variant, 3
4, 50707, item_name, price, 8, variant, 4
6, 50707, item_name, price, 0, variant, 6

For the store column, instead of the store id, you can set the store name.