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. ICECAT PRODUCT CATALOGUE DOWNLOADOnce all the settings are done, Click on continue on the top corner and the file download process would start. Unzip the file on your computer and upload it to the server. ICECAT PRODUCT CATALOGUE ZIP FILEThe download is usually no problem but after the file is downloaded CSVI needs to unpack the zip file and can easily run out of memory. This option is useful to download the large files index file as the size of this file is more than 100MB unpacked. In case you have troubles loading the files index make sure the ICEcat indexes folder does not have any files in it. If none of the files are found, CSVI will try to download the files from the ICEcat server. If any of the above files are found, CSVI will use these local files to import the indexes. If 5 does not exist, check if the file icecat_supplier.zip exists in the folder set by ICEcat indexes path.If 4 does not exist, check if the file icecat_supplier.gzip exists in the folder set by ICEcat indexes path.Check if the file icecat_supplier exists in the folder set by ICEcat indexes path.If 2 does not exist, check if the file icecat_index.zip exists in the folder set by ICEcat indexes path.If 1 does not exist, check if the file icecat_index.gzip exists in the folder set by ICEcat indexes path.Check if the file icecat_index exists in the folder set by ICEcat indexes path.On loading the index files, CSVI follows this process: The index files are loaded via the Maintenance tab: Once the ICEcat account has been created, on RO CSVI backend settings tab, Provide the user credentials used for creating the account and save it. The language codes can be found at the end of the document. You can replace INT with the language of your choice. Upload the downloaded file to your server to the file /tmp/com_csvi/icecat_supplier.Download the Manufacturer Index from or if you have a paid account from.Upload the downloaded file to your server to the file /tmp/com_csvi/icecat_index.Download the Files index from or if you have a paid account from.Use these steps to manually download the index files: In that case you need to prepare the files manually. The index files are increasingly getting bigger so it might not be possible to have RO CSVI download the files for you. Loaded into the database as CSVI VirtueMart will check this list if product information is available. The manufacturer index is a list of manufacturers that are available on the ICEcat server. This file must be loaded into theĭatabase as CSVI VirtueMart will check this list if product information is available. The files index is a list of URLs that are available on the ICEcat server. There are two index files that need to be loaded: These things are:Īn ICEcat account can be requested at the ICEcat website. To be able to use CSVI with ICEcat, a few things need to be setup first. You must have an account with ICEcat before you can access ICEcat data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |