Post by garbats » Fri Aug 12, 2022 4:39 am

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..
Image
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.
Last edited by garbats on Tue Aug 16, 2022 12:58 am, edited 1 time in total.

Newbie

Posts

Joined
Sat Jan 06, 2018 3:42 pm


Post by paulfeakins » Fri Aug 12, 2022 6:12 pm

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


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by garbats » Tue Aug 16, 2022 12:26 am

paulfeakins wrote:
Fri Aug 12, 2022 6:12 pm
Feel free to drop us an email for a quick estimate: info@antropy.co.uk
If you are interested in this job, the address is specified for you to send an email.
You can create your price offer by determining the requirements together.
Regards..

Newbie

Posts

Joined
Sat Jan 06, 2018 3:42 pm


Post by shivankagrawal » Tue Aug 16, 2022 4:46 pm

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/

Extensions Developed for Opencart | Portfolio Opencart | info@elderberrytech.com


Active Member
Online

Posts

Joined
Mon Jul 18, 2016 7:05 pm
Who is online

Users browsing this forum: paulfeakins, SohBH and 40 guests