Data synchronization (from OpenCart to 1C) in one-way exchange

Web Programming, Online Stores & E-commerce — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original

Goal

Set up one-way data exchange:

1C acts as the initiator (by pressing a button in 1C), "knocks" to the OpenCart site.
The site generates all necessary information about orders and clients (individuals or legal entities) using CommerceML (other options can be suggested).

List of synchronized fields

Field for individual or legal entity
Individual client (natural person):
- LastName (Last Name)
- FirstName (First Name)
- Country (Country)
Company (legal entity):
- Company Name (Company Name)
- Registration Number (Registration Number)
- VAT Number (VAT Number)
- Country (Country)
Order data:
- Order Date (Order Date)
- Invoice Number (Invoice Number — generated according to the scheme YYMMDD-XXX from Task 2)
List of goods/services (nomenclature):
- Product Code
- Name (Product Name)
- Quantity (Quantity)
- Price/Sum (Price/Sum)
Total amount (Total) with VAT rate:
- VAT Rate (VAT rate, for example 22% for Estonia).
- VAT Amount (tax amount) — can be transmitted as a separate field.
- If VAT Rate and/or VAT Amount are empty, it means the order is not taxable (0%).
- Payment system commission
- Total Amount — total for the order.
Payment Date (Payment Date)
- When the payment was made (if there is an online payment or partial payment).

Exchange scenario (one-way)

Initiator – 1C
- The user in 1C clicks "Get orders from the site" or starts the corresponding processing "Exchange with the site".
Request to the OpenCart site
- 1C sends a series of requests (CommerceML standard): mode=checkauth, mode=init, mode=query etc.
- The connection is secured with HTTPS (SSL) to avoid transmitting orders and personal data in plain text.
Formation of response data
- The "Exchange with 1C" module on the site collects the necessary orders (usually "new" or "not exported") and forms orders.xml
- All fields listed above (Last Name, First Name, Registration Number, etc.) are specified in the XML.

If the order is from a natural person, the fields for legal entities (Registration Number, VAT Number) remain empty — and vice versa.

Proposals 6 Discussions 1

Oleksandra Fedechko

0 0

Projects -
Rating -
Rating 183

Budget: 800 EUR Deadline: 1 day

Hello, I will help you with your order, I will do everything quickly and efficiently. Write to me on Telegram: Marokoko69, there I will send my portfolio.

Marsel Firsov

0 0

Projects -
Rating -
Rating 368

Budget: 1000 EUR Deadline: 10 days

Good day, I will complete your task. My experience as a web developer is over 10 years. I create websites of varying complexity on popular CMS.

Vitaly T.

34 0

Projects 29
Rating -
Rating 1 122

Budget: 110 EUR Deadline: 2 days

Hello.
I can implement it. Any version of Opencart. Any level of synchronization complexity.
Feel free to contact me.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Web Programming

CRM project for a car rental park + AI Assistant

AI Consulting 83 proposals 15:01

Not specified
Setting up TikTok Events API (server-side) on Horoshop for quality attribution (EMQ 60+)

Social Media Advertising 26 proposals 13:53

112 USD
Website enhancement on OpenCart 2.3

Website Maintenance 68 proposals 13:30

Not specified
Full-Stack Web3 Developer Needed to Improve and Complete an Existing DeFi Trading Platform

Cryptocurrency & Blockchain 32 proposals 2:35

16 000 USD
Development of a scalable B2B website (MVP) on Framer

Web Design 39 proposals 2:16

Not specified

Vladislav Ka
Tallin, Estonia
UXG

Projects 159
Rating -
Rating 4 388

Oleksandra Fedechko

Marsel Firsov

Vitaly T.

Proposals are currently absent

Current freelance projects in the category Web Programming

CRM project for a car rental park + AI Assistant

Setting up TikTok Events API (server-side) on Horoshop for quality attribution (EMQ 60+)

Website enhancement on OpenCart 2.3

Full-Stack Web3 Developer Needed to Improve and Complete an Existing DeFi Trading Platform

Development of a scalable B2B website (MVP) on Framer