import / export catalog joomla site with mijoshop
$10-30 USD
Płatność przy odbiorze
Platform: Mijoshop and Joomla
I need a software for uploading several items from .xls file to site/downloading several items from site to .xls file, with the following specifications:
UPLOADING FROM .XLS FILE TO MIJOSHOP DATABASE
1) The .xls file structure needs to be as the example attached, with the same fields
2) The field for the unique identification of products is the model field (field to check)
3) Categories and subcategories are separated by the character “ | “.
In uploading process from the .xls file:
If the category is not present, then do not import the product
If the category (or subcategory) in the file is not in the database, then creates the category
If the item (model field) in the file has a different category from the database, then creates the item in the new category, and remove it from the old
4) Upload photos:
First of all, copy images from file with the following rule: for new items (check model field), copy images from the link mentioned on the “image” column on ftp area of site with the address: fonugo//model field.
Then, upload items matching images from the link of ftp area
So all images will be taken from ftp address, but the process will be faster because only images of new products need to be uploaded.
5) Use the “Icecat” column as the “Supplier” column without rename it:
I update the database by taking the files from different suppliers (each item has a single supplier)
Updating products to follow this rule:
For new items of file…..Add them on Mijoshop database
For existing items…..Update all values on database
Finally for items of the processed supplier in Mijoshop database, but absent in the .xls file (check Model field and Icecat field) , put them unavailable (put “0” zero at quantity field) on Mijoshop database.
DOWNLOADING FROM MIJOSHOP DATABASE TO .XLS FILE
The file exported from Mijoshop database need to have the same structure of the .xls file used for importing the products.
Numer ID Projektu: #13239808