
Import/Export catalog from excel to mijoshop for joomla site
- or -
Post a project like this- Posted:
- Proposals: 3
- Remote
- #1501279
- Awarded
Description
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.
Giovanni C.
100% (3)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-

Gio
The idea is export products to joomla or import?
What is the logic?Giovanni C.19 Mar 2017Export from the .xls file attached on proposal to site and export from site to a .xls file with the same structure
TSOLUTIONS19 Mar 2017Gio
The process can be automated.
Can you provide access excel source, from where you getting the excel files?
The image are uploaded on joomla server
I. The key step here
- the excel file can be tweak to match the joomla database structure and imported.
2. If the excel files will be put on ftp then process can be automated
3. When you export from joomla database, the product comes out based on database structure.
To make it like excel original file, manual tweak will be required.
Please confirm