Hi,
I've been looking at the architecture to create an extension that connects to both Opencart and my other database (MongoDB) that has the most up-to-date quantity and price information, and syncs data at an interval.
However, I was wondering if instead of an extension what if I modify the Opencart DB directly, would it cause any issues in the backend or with any modules etc? Just wanted to be sure before I go ahead.
To reiterate, is OK to add and/or update products or product details directly from the DB?
Thanks!
hi
i dont think there will be any issue doing this as far as all relevant details in database is maintained.
i dont think there will be any issue doing this as far as all relevant details in database is maintained.
Good Day,
Jagruti
opencart tips and tricks ,
opencart blogs , opencart extensions/themes , custom development.
No problem at all but make sure you maintain relations across tables as OC doesn't have a foreign key check.
And please do a backup before each sync!
Are you planning to use a database sync tool?
It would be best imho if you can access the mongoDB via an interface/api so you could use php to update all related records by id.
And please do a backup before each sync!
Are you planning to use a database sync tool?
It would be best imho if you can access the mongoDB via an interface/api so you could use php to update all related records by id.
Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ 
Thanks!
Ah great, thanks for the confirmation!
No the two databases are not identical. mongodb has tons of other fields, I'm just going to use MPN as the common index between the two and update only price and quantity once the products are in OC, hope that should work without any issues?
No the two databases are not identical. mongodb has tons of other fields, I'm just going to use MPN as the common index between the two and update only price and quantity once the products are in OC, hope that should work without any issues?
Sounds good to me!
So out of curiosity, what are you using to sync them?
So out of curiosity, what are you using to sync them?
Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+
Thanks!
So I added a few Manufacturers directly to DB and although it shows the name fine in the Admin, but the image doesn't show up, not does it show in the frontend:
Error:
Brand not found!
... whereas manufacturers added via admin shows up fine. Am I missing something here?
Thanks
Error:
Brand not found!
... whereas manufacturers added via admin shows up fine. Am I missing something here?
Thanks
Did you set the status to "Enabled"? If so, try clearing your cache (probably a good idea to do that anyway).
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Who is online
Users browsing this forum: Google [Bot] and 8 guests
