Post by opencenterbymodart » Mon Jun 22, 2020 11:30 pm

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!


Posts

Joined
Fri May 08, 2015 7:53 pm

Post by OSWorX » Mon Jun 22, 2020 11:51 pm

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 ..

Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by opencenterbymodart » 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?


Posts

Joined
Fri May 08, 2015 7:53 pm

Post by OSWorX » Wed Jun 24, 2020 2:59 pm

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

Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by Cue4cheap » Fri Jun 26, 2020 10:12 pm

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

cue4cheap not cheap quality


Expert Member

Posts

Joined
Fri Sep 20, 2013 4:45 am

Post by opencenterbymodart » 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?!


Posts

Joined
Fri May 08, 2015 7:53 pm

Post by by mona » Sat Jun 27, 2020 2:51 am

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

DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am
Who is online

Users browsing this forum: No registered users and 100 guests