Update prices

Hey there, @gerard-ter-beke! Thanks for contacting us. I’m happy to help you.

As you mentioned, the only way to match is by using the ID or SKU.

What I suggest doing to update the prices is:
– Export either all products or only the ones you want to update
– When exporting, you can either export all columns, or choose the ones you want to export. You can choose to only export the name, ID/SKU and price, for example
– Open the file on Excel, Google Sheets or another compatible software
– Edit the prices and save the file
– Import the file making sure you checked the update checkbox

You can find more about this in this guide.

The alternative would be to export all products, match the [name] with the [ID] in Excel, somehow match the prices to the correct products and import the new file based on [ID].

If you export the columns, the name and ID will be on the same line, so you won’t have to search and match it yourself ??

For example, in the product below, I choose to export only ID, Name and price. So I can easily see the name of the products and the ID will already be matching ??

I hope this was clarifying. Please let us know if there’s anything else we can do to help or if you have any questions.

Have a wonderful day!

Hi @carolm29,

Thank you for replying! I understand this is the way to go, however, it defeats the ease of updating. Instead of updating through an easy import function I now have to manually update the prices in the Excel and reupload. Granted, it is faster, but at some 15k products it’s still a hell of a task.
Many of our suppliers release new pricelists based on their partnumber. They do not include the SKU (EAN/GTIN), some products don’t even have an SKU. I think I’ll need to write some Excel macro to match ID with partnumber and update.

Hey, @gerard-ter-beke!

Do you mind sharing more details about how you wanted it to work so we can see if we can find another solution?

How do you get the price list? Is it a CSV?
You mentioned that if the match could be done by name, you wouldn’t need to edit it on Excel, right? Do you mean you wanted to import the file you get directly to Woo?

Looking forward to your reply.

Have a wonderful day!

Hi @carolm29,

I have screenshotted a few examples of pricelists as we receive them:
https://snipboard.io/bivSJM.jpg
https://snipboard.io/8Cnhck.jpg
https://snipboard.io/bK6v8R.jpg
https://snipboard.io/RcijZM.jpg

As you can see most pricelists consist of the name (partnumber) of the product, a description and the new price. I could use the name as the SKU, but that would be ugly in the presentation on the site. So, I have opted to use the partnumber as the name, and use the EAN/GTIN as the SKU.
Upon request most manufacturers will send the information they have available, like here:
https://snipboard.io/KNkyRX.jpg
As you can see most parts have an EAN code, but when receiving new pricelists these aren’t included. So, ideally I would like to define the field to match (name, SKU, ID, even description) and tell Woocommerce which fields from the CSV to put where (like it is now). You could even define a setting like ‘match the [name] field on condition that [attribute_manufacturer]=’Apple’

Does this sound logical? Am I doing something wrong, or using the database in the wrong way?

Hello Gerard ter Beke,

Thank you for your reply.

I understand you want to update the prices of your products.
As already discussed WooCommerce requires an identifier like SKU to update products.

Ideally I would like to define the field to match (name, SKU, ID, even description)

Would it be possible for you to perform this action in your Spreadsheet software?
I suggest you consult a Spreadsheet software expert to explore this idea.
There might be a way to configure your Spreadsheet with formulas to generate a new CSV file that fulfills your requirement.

Another solution will involve custom coding to match relevant fields and update the product.
For that, I recommend consulting a web developer.
You can find one at WooExperts or Codeable.

I hope this helps. ??

Best regards.