FROM CACHE - en_header

Simple... I just want to update product pricing via CSV

Solved
Angela_Hardiman
Excursionist
42 0 48

I need to update pricing on the products we are selling in bulk via CSV file.  I get updates on pricing, etc just about every month.  I don't want to change anything else.  How can I import just the new product price without changing anything else. I don't want an app. Can I just import a file with the Variant SKU and the new Variant Price.  If I override will it eliminate all of the other information?

I don't have time to update each individual price as it takes way too much time.  There are tens of thousands of products.

Accepted Solution (1)

Accepted Solutions
Maris
Shopify Partner
313 5 68

This is an accepted solution.

Hey, Angela!

There is this app https://excelify.io that does exactly that (and not only that).

You can import the file with two columns:

  • Variant SKU
  • Variant Price

and it will update the price for all product variants that have that SKU.

Here’s the tutorial how to do that: https://excelify.io/2018/02/12/update-shopify-product-by-sku/

Maris

Matrixify (Excelify) | Bulk Import Export Update Migrate | https://matrixify.app

View solution in original post

Replies 51 (51)
Maris
Shopify Partner
313 5 68

This is an accepted solution.

Hey, Angela!

There is this app https://excelify.io that does exactly that (and not only that).

You can import the file with two columns:

  • Variant SKU
  • Variant Price

and it will update the price for all product variants that have that SKU.

Here’s the tutorial how to do that: https://excelify.io/2018/02/12/update-shopify-product-by-sku/

Maris

Matrixify (Excelify) | Bulk Import Export Update Migrate | https://matrixify.app
Angela_Hardiman
Excursionist
42 0 48

Maris,

Thank you for your reply.  In my post I stated I do not want an app.  I just get responses in this manner that have directed me to apps that do not work the way I want them.  With my amount of products I would be paying hundreds to thousands of dollars every month for little things needed.  I know it is possible through the regular shopify information but I have yet to find it again.  

Maris
Shopify Partner
313 5 68

Oh, so sorry, Angela!

I was so excited to help you that I skipped over that sentence and did’t really notice it.

That’s super rude of me.

Terribly sorry.

Maris

Matrixify (Excelify) | Bulk Import Export Update Migrate | https://matrixify.app
Dustan
Tourist
5 0 8

I have yet to find a way to do this as well seems like a very basic thing that should exist why require me to upload everything just to change price on a csv or qty even. Please Shopify fix this issue. Shouldn't have to pay up to $20 to $200/mo just to bulk update prices which should be a basic feature.

Angela_Hardiman
Excursionist
42 0 48

Yes,

 

Dustan it seems that Shopify just wants to make money off of apps.  This has still after a year continues to be unresolved.  You would think that this would be simple to do.  We can update inventory but not the price fields.  

Dustan
Tourist
5 0 8

Yeah I settled with Excel-like Spreadsheet Bulk Product Manager it is 6.99/mo or 99.99 for lifetime trying the 6.99 but so far so good then will get the lifetime. Can use sku or id or even upc and just one column to update whatever you want. I have about 4000 skus did it pretty quickly again should be standard but can't build my own cart so here I am best of the worst.

Derek_Morin
Shopify Expert
215 1 34

I don't think there is a way to achieve this without any app (private or public). That being said, here's how you can schedule automatic updates for your SKU pricing with Moose Sync.

 

rmanke
Shopify Partner
158 0 40

You can selectively import only the columns you want to change, such as the price.  There is no need to import every column in the spreadsheet.  

 

You DON"T need an app to do this.  It's basic Shopify functionality.

 

 


@Angela_Hardiman wrote:

I need to update pricing on the products we are selling in bulk via CSV file.  I get updates on pricing, etc just about every month.  I don't want to change anything else.  How can I import just the new product price without changing anything else. I don't want an app. Can I just import a file with the Variant SKU and the new Variant Price.  If I override will it eliminate all of the other information?

I don't have time to update each individual price as it takes way too much time.  There are tens of thousands of products.


 

Shopify Partner, software developer and designer.
Ricardas
New Member
3 0 0

Hi,

 

I have tried updating prices only.

There are two strange things here:

 

1. Only SKU isn't enough, for some reason title is required for import.

I solve it adding it. Not a big deal

 

2. Some strange side effect is that after price import the inventory levels are set to 0.

 

I don't want to load inventory every time with a price - is there a reason why it works this way and some reasonable workaround?

 

Regards

Ricardas

 

P.S. I use csv as

Handle, Title, Variant SKU, Variant Price, Variant Compare At Price

rmanke
Shopify Partner
158 0 40

It won't update the inventory levels unless you include the inventory column titles.

 

You do not want the column headings for anything you aren't wanting to change.  Otherwise, it may empty those data fields.

 

So, if you only empty the values, but left the headings in the sheet, then you may have problems. 

 

For example, if you just want to change the prices, this is how it should be formatted in Excel:

 

Annotation 2020-04-09 164830.jpg

 

If you have variants, then this is how it should be formatted:

 

Annotation 2020-04-09 165128.jpg

 

I have done this hundreds of time with no problems.  If you need help, let me know.  More people need to know how to do this.

Shopify Partner, software developer and designer.
Dustan
Tourist
5 0 8

So you have to use handle and can't use Variant SKU?

rmanke
Shopify Partner
158 0 40

Handle ALWAYS has to be in the import file.

 

Your handle could be your SKU if you want, but the first column HAS TO BE named 'Handle" and not have any spaces or special characters in it.

Shopify Partner, software developer and designer.
AlliedCloud
Tourist
3 0 1

Hi RManke,

Sounds like you might know the definitive answer to this. I need to add SKUs/variant SKUs to all the items in a Shopify account. Right now they're all blank. Is this possible via CSV? I've tried, and the preview appears to show the value in the file, but it doesn't actually add it. Thanks in advance.

rmanke
Shopify Partner
158 0 40

It will definitely work.  It's possible the column headings don't have the exact same spelling?

 

If you contact me, and get me your sample files, I can help debug.

 

Or you could post a screenshot here.

Shopify Partner, software developer and designer.
AlliedCloud
Tourist
3 0 1

Thank you. I figured out which field was missing. Quick question though. If I only include two or three fields in the import, are they the only fields affected? I didn't include the Description (body html) field in the first one and the preview showed the Description field blank.

rmanke
Shopify Partner
158 0 40

Yes, that is something that is not well documented.  I believe the ONLY mandatory fields, are the handle and the title.  Everything else is ignored unless you include it in the CSV file.

 

And, if you DO include it in the CSV file, it will be the only fields affected upon the import.  This is the secret sauce to being able to manage your products like a pro!

Shopify Partner, software developer and designer.
AlliedCloud
Tourist
3 0 1

Excellent. Thanks, Ron.

PS - I'll reach out directly if/when our customers need help in the future.

Kevin5801
Excursionist
17 0 18

@rmanke 

Just to add to your solution - When you upload your new CSV your preview will look similar to this
upload preview.png

 

The blanks will not be overwritten or replaced with "blank" info

 

winjo
New Member
3 0 0

Please rmanke enlighten us on how to do this. I have pretty much wasted an entire day trying.