import / export catalog joomla site with mijoshop

Zamknięty Opublikowano 7 lat temu Płatność przy odbiorze
Zamknięty 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.

Przetwarzanie danych Handel elektroniczny MySQL PHP

Numer ID Projektu: #13239808

O projekcie

7 ofert Zdalny projekt Aktywny 6 lat temu

7 freelancerów złożyło ofertę za $32 w tym projekcie

fmsufi

Hi!! This is Ms. Farhana. I read your job details . I can do . You will be 100% satisfied it is guaranteed . I am honest in my work and also my word. Thank you in advance for your time and consideration. I loo Więcej

$25 USD w ciągu 1 dnia
(4 Oceny)
1.8