Feature requests for IOS Eshop 1.5

[speck]

You need import the products from an different db (access, filemaker, mssql or mysql) into the IOS eshop DB?

[StefanSultanov]

Basically I need to load huge product list in several categories.
The info I will have is on a Spreadsheet.
Using Open Office Calc I can format it as I desire to fit the sql format (used in MySQL Database tables).
IOS was kind enough to provide me the actual tables that are used to describe products.
The trouble is that the products are described in several tables and the structure is pretty complex for me.
IOS recommended to build a PHP script to do the bulk product load.

Basically it is not a data migration task. It's more about speed and automation. I can enter the products one by one naturally, but it can take me a year to do.
My intention is to study the table structure and mimic the records using a spreadsheet columns.
Then to populate the tables one by one in .sql file format.
However I'm not sure that this is the right approach. I'll get at least 6 or 7 separate spreadsheets that I must keep consistent and related to each other.
It will be much simpler to use a single spreadsheet for the job, because the error probability will be cut down next to zero.
Any Ideas?
Please note that I use eShop 2.0

[CREATIVE Options]

Hello StefanSultanov,
As you understand your needs it is very custom to be included in a general release.

Of course this task can be done. But it has to created specific for your spreadsheets.
If you can provide me with an exact copy of your spreadsheets, and your operating needs I will inform you for the total time of developing the custom script and the cost of it.

I am at your disposal,
info [at] creativeoptions [dot] eu
+30.26610.22726
+30.6936.641.341

[StefanSultanov]

Thanks Sirigos!

Check mail