November 12 2022

Magento exchange with 1C

I am sharing my updated one-sided solution for a bundle of 1c and Magento 1.9.* In Automatic mode.
1C UT 10.3 upload mechanism --->.csv file ---> magmi ---> Magento

Processing can allow you to unload different warehouses, different groups, different prices. A kind of "multi-warehouse".
To implement, read my instructions and the Magmi instructions and think a little.

The 1C code acts as the SKU. For each product in 1C, it is unique and the most convenient option for synchronization.
P.S.:
In my case, the "1c product characteristics" are not used, because this function is not declared in processing. Consider this point.
PS:
The characteristics of the product and the properties of the product in 1C are different things. Product properties processing supports.

Processing does not require integration into the 1c configuration!

Spoiler: Description
Processing is created for automatic exchange between 1c UT 10.3 and Magento 1.9 via Magmi.
It polls commodity items and creates a file .csv ready to upload to Magmi.
Main functions and parameters:
The "Upload to disk" tab.
This tab contains the main elements of unloading the price list in .csv format. The extension itself and the encoding of the file are already registered in the processing, these parameters are changeable only in the configurator.
Available tab fields:
1). Upload settings directory.
This function saves the upload settings you specified for further automatic processing and quick access. (Attention! If you make changes to the processing in the configurator, and then upload the old settings file, your changes!executed now! processing will reset and may "fail")
2). Group - which groups of the item you want to upload to the file.
3). Warehouse - which warehouses of the nomenclature you want to upload to the file.
4). Date - on what date you want to upload. By default, it is the current one.
5). Price type - the prices you want to upload. For more details, see the description of the "Uploaded information" tab.
6). The exchange directory on the disk is the directory where the .csv file will be uploaded and from where the processing will send it to FTP.
7). File name - the name of the file in the directory on the disk. Expansion.csv is substituted automatically, you do not need to specify it in the file name. At the same time, if a file with this name already exists in the upload directory, processing will overwrite it!
8). Image catalog is a tested functionality for uploading images from 1c to FTP. It will be available in future versions.

The "Upload to FTP" tab
Basic parameters of the FTP connection. Attention! Processing does not work with SFTP and FTPs. Main port = 21. (Can be changed in the configurator.)
1). FTP host: - your FTP server IP address in the form - 192.168.1.1
2). FTP login: - FTP username
3). FTP password: - FTP user password
4). FTP directory: - directory where it is necessary to upload the file. End the catalog with /
In my case, I created an FTP user with access only to the directory /magento/var/import/ which reads Magmi.
5). File name on FTP: - file name.csv uploaded to your FTP server.
The extension is inserted automatically, it is not required to specify.
If a file with this name exists, processing will overwrite it.
!Don't forget to give out permissions for the FTP user to write!

The "Uploaded Information" tab
1). "Category" - unloads product categories in a format readable by Magmi - "categories". I.e. if your categories in the database and on the site are the same, you do not need to put the product in folders.
2). "Product code" - unloads the "code" of the product in the "sku" column.
3). "Article" - unloads the "article" of the product in the "art" column. (Non-standard Magento attribute)
4). "Name" - unloads the "name" of the product in the "name" column
5). "Barcode" - unloads the "barcode" of the product in the "barcode" column
6). "Remainder" - unloads the "remnants of the goods in warehouses (all or one) in the qty column
7). "Prices" = unloads the prices of the goods.
For this function, you need to assign the following parameters:
In the "Item Price types" directory in your database, fill in the comment field for each desired price. For example:
Retail price = comment = price
Discounted price = comment = special_price
The name of the prices in your database does not have to be like this. Processing will poll only the "comment" field.
8). "Description" - processing will poll the "Additional description of the nomenclature" field of the product and fill in the "description" column
9). "Comment" - will poll the "comment" field of the product! and fill in the "comment" column (I don't use it myself)
10). "All goods" - this function will poll all goods at the warehouse you specified, even if they are actually out of stock and they do not have the prices you specified. At the same time, the goods missing from the warehouses of the enterprise will receive the number "2" in the "status" column - Magento will set the status "disabled" for them during import and the product page will be unavailable in "fronted", i.e. 404.

The "Auto-exchange" tab
Processing can perform upload and exchange with FTP in automatic mode. To do this, the following conditions must be met:
1). Create a new user in the 1c database with the name Auto and password 159159
2). Start processing under a regular user.
3). Fill in the FTP settings, unloaded groups and warehouses, price type.
4). Fill in the catalog of unloading settings. For example D:\Obmen-s-site\Settings
5). Check the box "Close processing after unloading".
This function will automatically close 1C with the Auto user after uploading to disk and to FTP in 15 minutes. This time is specified for unambiguous file transfer to FTP with all timeouts.
6). !!! Save the upload settings on the "Save settings" button.
This will save your FTP settings, warehouses, prices, etc. to a separate file on disk.
7). !!! Save form values. (Next to the action button at the top)
This will save your upload settings directory. If it is not there, the processing will not find the necessary settings when automatically starting.
8). Configure the attached file.bat
"Path to 1C" enterprise /F"Path to database" /NAuto /P159159 /Execute"The path to processing" /A saved adjustment to the booting process
Sample file:
"C:\Program Files (x86)\1cv8\common\1cestart.exe" enterprise /F"D:\UT" /NAuto /P159159 /Execute"D:\Obmen-s-site\exporttocsv.epf" /C1

For a full automatic exchange, configure the task scheduler in Windows where you have a database with 1c,
And cron on the site for automatic Magmi operation on a schedule.
Code for Cron Magmi:
! php /Path to the root folder сайта/magmi/cli/magmi.cli.php -mode=create -profile=default
Decoding:
-mode=create - will update the current positions and create new ones.
-profile=default - execution profile. You can create multiple upload profiles with different uploaded files. See the Magmi documentation.
Attached to the file .bat - for the task scheduler and scheduled upload settings.
It is planned to add the function of uploading photos from 1C to the site. The mechanism is already there, but not debugged. Unloading properties from 1C works, but it is not included in the description, so test it.

Information

Visitors who are in the group Guests they can't download files.
Log in to the site under your login and password or if you are a new user go through the process registrations on the website.

Comments:

This publication has no comments yet. You can be the first!

Information the publication:

  • Author of the publication: cmsred
  • Date of publication: 12 November 2022 10:01
  • Publication category(s): Magento script / Modules Magento
  • Number of views of the publication: 135
  • Number of comments to the publication: 0

Related News

12 November 2022
PrestaShop script / Modules PrestaShop
Module Import/Update

Easy automatic loading, import of product information, images, stocks, combinations, functions, options,

Read more
12 November 2022
Magento script / Modules Magento
Amasty Automatic Related

the latest version of Amasty Automatic Related Products for magento 2.4

Read more
12 November 2022
PrestaShop script / Modules PrestaShop
Module Additional

Sell products with paid attributes, specify parameters, or simply get additional information from customers using

Read more
12 November 2022
Magento script / Releases Magento
Releases Magento

Releases Magento Open Source delivers features to build and grow a unique online store from the ground up.

Read more
12 November 2022
CMS Internet shop Scripts / Magento script / Modules Magento
Quick One-step

Put all the checkout steps on one responsive page to simplify the entire purchase process. Use customizable

Read more

Information

Users of visitor are not allowed to comment this publication.

Site Search

Site Menu


☑ Scripts Software

Calendar

«    May 2024    »
MonTueWedThuFriSatSun
 12345
6789101112
13141516171819
20212223242526
2728293031 

Advertisement

Survey on the website

Evaluate the work of the site
 

Statistics

  • +4 Total articles 5598
  • +23 Comments 3088
  • +33 Users : 3989