Generating Products & Attributes from Imported Data File

[pockets]

Hi - can anyone help me please?

I want to upload a CSV file and use the contents to generate Products, Attributes and Products with Attributes Stock.

When I have the data imported as-is into a table, I work through it and create the product records and want to generate the product options, values and stock for the different sizes.

What I am stuck on - is the products_options_id and any others that aren't autoincremented.

I see that there is a function call to zen_db_prepare_input used to create this value - but I don't understand it.

Can anyone explain how I get the next insert ID for these files?

[schoolboy]

Easy Populate is the probable route to go.

Go to:

http://www.modhole.com/modhole/index..._Document_id=2

And download version 1.2.5.4

There is my Easy Populate tutorial on the WIKI

http://www.zen-cart.com/wiki/index.php/Easy_Populate

(NB: Easy Populate ADVANCED is the commercial version and is better programmed to handle attributes - available at MODHOLE)

[pockets]

Hi schoolboy

I have looked at Easy Populate, but this is something I want to use regularly to upload the current stock picture from a VFP Stock & Accounts system.

I have the answer to this particular problem - I'll just use SELECT MAX(id) FROM file_name and increment this value. (Hopefully that works)

Thanks for the quick response.

[pockets]

OK - I have got all the PHP / SQL code working to generate the categories, products, attributes and stock from my data that I've imported into a table via phpMyAdmin

Now - I need to be able to locate a file uploaded by ftp and automatically read this data into the temporary table, then delete / move the CSV file.

Any ideas how to do this?