![]() ![]() What happens now on import is that not the column product_sku is used as unique identifier but the column product_mpn. In this example the database column is called product_mpn. On import you must also set in your template settings to use the MPN column instead of the product SKU as shown below. If your product SKU is not the same as the MPN you must add a field to the VirtueMart product table to store the MPN. ICEcat identifies products based on the MPN (Manufacturer Part Number) and manufacturer name. When performing the ICEcat index loading using cron, the 1 step import is used. This time is when the import pauses to reduce the load on the server This is the number of lines that is imported on each step. To load the file in multiple steps set the following options: In case it is not possible to load the files index file in 1 step, it is possible to load it in multiple steps. Once the files are downloaded, RO CSVI would notify the process is completed. This command can be enabled in the MySQL configuration file. To be able to load the index files, the MySQL needs to be configured to use the ![]() When the INFILE command is not enabled the error: Error occurred: The used command is not allowed with this MySQL version appears. To be able to load the file in 1 step the INFILE command needs to be enabled on the server. By default CSVI will load the files index in 1 step because this is the fastest and most efficient way of loading the files index. The index file is a big file with over 500,000 entries. Actual import process would be done same as the Product Import . Please note that this process would just look for the index files and would download. Once all the settings are done, Click on continue on the top corner and the file download process would start.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |