Have your say in Community Polls: What was/is your greatest motivation to start your own business?

CSV File error

CSV File error

RouhabJPR
Visitor
2 0 0

I am getting two errors while uploading my CSV which are listed below

  • Inventory policy is not included in the list.     (I have listed the option as "Shopify tracks this product's quantity")
  • Option value provided for unknown options

The second error can't be cleared for some reason.

 

I have attached my CSV below

Replies 3 (3)

Dan-From-Ryviu
Shopify Partner
10261 2039 2110

Hi @RouhabJPR 

The value you must add in "Variant Inventory Policy" column should be "DENY" or "CONTINUE" only. 


CONTINUE: Customers can buy this product variant after it's out of stock.
DENYCustomers can't buy this product variant after it's out of stock.

- Helpful? Like and Accept solution! Or Support me: Buy Coffees
- Reton: Loyalty & Rewards - Earn points through tasks, redeem for discounts, and enjoy exclusive VIP rewards!
- Ryviu - Reviews & QA app: Collect product reviews, import reviews from AliExpress, Amazon, Etsy, Walmart, Shopee, Dhgate and CSV.
- Lookfy Gallery: Lookbook Image: Easy and fast to create Photo Gallery, Lookbook, Shop The Look.
- Reelfy‑Shoppable Videos+Reels: Create shoppable videos to engage customers and drive more sales.
- Enjoy 1 month of Shopify for $1. Sign up now.

Ablestar_Daniel
Shopify Partner
136 23 46

Hello,

 

Using the Shopify admin to upload spreadsheets requires that your file matches their format exactly, which can be a little tricky sometimes. I took a look at the file and was able to fix it by making the following changes:

  • The "Variant Inventory Policy" column should have the text "deny". (Or "allow" if you want to allow the product to still be sold when there's zero inventory)
  • The "Option2Value" needs to be renamed to "Option2 Value", the space in there is causing the issues

After making those changes the file appears to work:

Screenshot 2024-06-12 at 9.32.15 AM.png

 

I hope this helps,

 

Daniel

Founder @ Ablestar ✦
Manage product data, spreadsheets, Google Shopping data, and metafields with Ablestar Bulk Product Editor. Use previews, undos, and automations to be confident your product data is correct.
Please don't forget to Like and Mark Solution to the post that helped you. Thanks!
RouhabJPR
Visitor
2 0 0
Hi,
I got the issue fixed before but thanks for the help