Microsoft SQL Server Database Integration Script for Opencart 3x
It is necessary to integrate 3 different areas for the products for the accounting program used for the workplace and the opencart website. It can be done as a script on the main machine. And I think it can be updated with a cron job.
The product field to be updated for Opencart ;
Product name, product price, product stock number(upc field)..
I took a screenshot for the table structure. It is announced to friends who can do this customization and work with us in other works.
my note;
As far as I understand the events here are as follows;
The stock codes(upc field) of the products coming from the sql manager will update the price, name and stock quantity values of the products that match the stock code in mysql, if there is a product without stock code in mysql, a new product will be created. and by default it will also complete fields for newly added products such as description meta info etc..
img;https://im.ge/i/Fe6DwD
info@cumleyazilim.com
Cümle Software LLC
Ali A.
Edit>>
It will be a one-sided data transmission.
The update will be done in 15 minutes as much as possible.
(could be lower too)
for newly created products it should also be created in the oc table.
The product information to be transferred in MSSQL is as follows;
product barcode,
product name,
the price of the product,
category of the product,
the manufacturer of the product,
the remaining stock of the product,
These data will update the values of the product data fields in opencart.
If the product stock code from MSSQL does not exist in the opencart database, it will create a new product record.
Feel free to drop us an email for a quick estimate: info@antropy.co.uk
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Guru Member
If you are interested in this job, the address is specified for you to send an email.paulfeakins wrote: ↑Fri Aug 12, 2022 6:12 pmFeel free to drop us an email for a quick estimate: info@antropy.co.uk
You can create your price offer by determining the requirements together.
Regards..
Hello,
Greetings! I have read the job description and have relevant experience in an Opencart and am ready to help you. I can do this integration for you.
Or you can email me at: info@elderberrytech.com to discuss further.
Thanks,
Shivank Agrawal
https://elderberrytech.com/
Greetings! I have read the job description and have relevant experience in an Opencart and am ready to help you. I can do this integration for you.
Or you can email me at: info@elderberrytech.com to discuss further.
Thanks,
Shivank Agrawal
https://elderberrytech.com/
Extensions Developed for Opencart | Portfolio Opencart | info@elderberrytech.com
Who is online
Users browsing this forum: No registered users and 40 guests