Re: Uploaded csv and all products showing up as $0. Never happened before, what am I missing?

Solved

Uploaded csv and all products showing up as $0. Never happened before, what am I missing?

brandunleashed
Shopify Partner
23 2 3

Hi,

I've been doing fine with CSVs, but this one file is not working. I've attached the CSV-- why are they all coming up as $0 once imported?

Accepted Solutions (2)

Hilary
Shopify Staff (Retired)
551 79 133

This is an accepted solution.

Hi, @brandunleashed

Happy to lend a hand here. I've had a look at the CSV file you shared, and it looks like the column headers have been edited. The first line of your product CSV file must be the column headers that are included in the sample CSV file and in the same order. You can't alter these titles, otherwise the products will not import successfully. Please follow our template linked here. Furthermore, if a required column in the import CSV file is blank, then the matching value in the product list is overwritten as blank. I can see that some values are not entered on the spreadsheet you attached. Filling in these values should help resolve this issue. 

The price column headers should be: 

  • Variant Price
  • Variant Compare at Price

There is a full list of the column headers in our help document. As well, a more detailed explanation about how overwriting products works. Once you've adjusted the column headers, and added values for each variant, let us know how it goes trying to import the CSV again. Thanks! 

To learn more visit the Shopify Help Center or the Community Blog.

View solution in original post

Hilary
Shopify Staff (Retired)
551 79 133

This is an accepted solution.

Fantastic, happy to help! 

To learn more visit the Shopify Help Center or the Community Blog.

View solution in original post

Replies 6 (6)

PaulNewton
Shopify Partner
6382 583 1358

What's the behavior if you import just 1 item?

What's the behavior if you just export 1 item then immediately reimport it?

Save time & money ,Ask Questions The Smart Way


Confused? Busy? Get the solution you need paull.newton+shopifyforum@gmail.com


Problem Solved? ✔Accept and Like solutions to help future merchants

Answers powered by coffee Buy Paul a Coffee for more answers or donate to eff.org


brandunleashed
Shopify Partner
23 2 3

Sorry for the late reply, let me test this and post in a moment.

brandunleashed
Shopify Partner
23 2 3

I exported a product with prices and then imported, and it imported fine.

Hilary
Shopify Staff (Retired)
551 79 133

This is an accepted solution.

Hi, @brandunleashed

Happy to lend a hand here. I've had a look at the CSV file you shared, and it looks like the column headers have been edited. The first line of your product CSV file must be the column headers that are included in the sample CSV file and in the same order. You can't alter these titles, otherwise the products will not import successfully. Please follow our template linked here. Furthermore, if a required column in the import CSV file is blank, then the matching value in the product list is overwritten as blank. I can see that some values are not entered on the spreadsheet you attached. Filling in these values should help resolve this issue. 

The price column headers should be: 

  • Variant Price
  • Variant Compare at Price

There is a full list of the column headers in our help document. As well, a more detailed explanation about how overwriting products works. Once you've adjusted the column headers, and added values for each variant, let us know how it goes trying to import the CSV again. Thanks! 

To learn more visit the Shopify Help Center or the Community Blog.

brandunleashed
Shopify Partner
23 2 3

Thanks so much! I was off on the wording for a couple headings, and that fixed it!

Hilary
Shopify Staff (Retired)
551 79 133

This is an accepted solution.

Fantastic, happy to help! 

To learn more visit the Shopify Help Center or the Community Blog.