Page 1 of 1

Automatic product price update module

Posted: Mon Jun 22, 2020 11:30 pm
by opencenterbymodart
Hello everyone!
I am using Opencart 2.3.0.2 with Pavilion theme.
I am looking for a module that can automatically update my product prices for my webshop. So basically if I have a Google Spreadsheet in which I change the price of 3 products, later (or at the set time) the module updates the products price automatically.
Unfortunately I don't have a developer right now and I don't really have time to update all the prices, I have to make it by myself.
Is there a solution for this? Downloading, then uploading the product list with the prices takes too much time, I need it to be automated.
Thanks in advance!

Re: Automatic product price update module

Posted: Mon Jun 22, 2020 11:51 pm
by OSWorX
Only 3 products?

I am asking, because the next few days a "price updater" module will be published.
But intended to update all products at a given date ..

Re: Automatic product price update module

Posted: Tue Jun 23, 2020 9:52 pm
by opencenterbymodart
No. It's fine if all of the product's prices are updated automatically, I don't mind.
But I need it to read it from a spreadsheet where whenever I change a price it will change on the site too.
Is it possible? Will it work with 2.3.0.2?

Re: Automatic product price update module

Posted: Wed Jun 24, 2020 2:59 pm
by OSWorX
No, my new extension will be a module and use no external sheets or something like .txt, csv, etc.
Maybe you try it with that here: https://www.opencart.com/index.php?rout ... sion_id=17

Re: Automatic product price update module

Posted: Fri Jun 26, 2020 10:12 pm
by Cue4cheap
opencenterbymodart wrote:
Tue Jun 23, 2020 9:52 pm
No. It's fine if all of the product's prices are updated automatically, I don't mind.
But I need it to read it from a spreadsheet where whenever I change a price it will change on the site too.
Is it possible? Will it work with 2.3.0.2?
What you'll need to have is an extension that can be ran by a cron job, get the spreadsheet (or csv file), match the product in the spreadsheet to the product in the database and update the price. THEN if you have specials you'll most likely want to have those updated too.
You might want to look at the marketplace and see if there is something there.
Mike

Re: Automatic product price update module

Posted: Sat Jun 27, 2020 12:18 am
by opencenterbymodart
Unfortunately I can't seem to find such extension.
It would be fine to export my spreadsheet to excel and then upload it, but this would be best if made automatically.
Is there, maybe, such an extension at all?!

Re: Automatic product price update module

Posted: Sat Jun 27, 2020 2:51 am
by by mona
opencenterbymodart wrote:
Sat Jun 27, 2020 12:18 am
Unfortunately I can't seem to find such extension.
It would be fine to export my spreadsheet to excel and then upload it, but this would be best if made automatically.
Is there, maybe, such an extension at all?!
https://www.opencart.com/index.php?rout ... n_id=31328
https://www.opencart.com/index.php?rout ... load_id=47