Import

[Guest ByondF1]

Is there any kind of import available for loading your site. I have over 1000 products and it is going to take me forever to get my gatalog populated.

I really hope there is one. I can format the data in just about any format but need a program to import it into the databases.

Thanx in advance.

[Guest estelle]

Do you have access to phpMyAdmin, or some way of running SQL commands on your server?

I have my inventory, categories, and links between products and categories all setup a spreadsheet. I then save/export these three spreadsheets as CSV files and run the following SQL commands on my server to delete and repopulate the whole of my categories/products. This LOAD DATA LOCAL INFILE command means that phpMySQL will retrieve the file from your local machine and send it to the server. Pretty hand . Or if this isn't working, take out the LOCAL and first FTP the files to your server.

Modify wherever necessary (refer to www.mysql.com), and use at your own risk ...

TRUNCATE TABLE --xxx--_CubeCart_category;

LOAD DATA LOW_PRIORITY LOCAL INFILE 'C:/Documents and Settings/--xxx--/My Documents/--xxx--/categories.csv'

    INTO TABLE --xxx--_CubeCart_category

    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\'

    LINES TERMINATED BY '\r\n' STARTING BY ''

    IGNORE 1 LINES;



TRUNCATE TABLE --xxx--_CubeCart_inventory;

LOAD DATA LOW_PRIORITY LOCAL INFILE 'C:/Documents and Settings/--xxx--/My Documents/--xxx--/inventory.csv'

    INTO TABLE --xxx--_CubeCart_inventory

    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\'

    LINES TERMINATED BY '\r\n' STARTING BY ''

    IGNORE 1 LINES;



-- Links

TRUNCATE TABLE --xxx--_CubeCart_cats_idx;

LOAD DATA LOW_PRIORITY LOCAL INFILE 'C:/Documents and Settings/--xxx--/My Documents/--xxx--/cat_inv_links.csv'

    INTO TABLE --xxx--_CubeCart_cats_idx

    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\'

    LINES TERMINATED BY '\r\n' STARTING BY ''

    IGNORE 1 LINES;

Note: if you wanted to, you could try taking out the TRUNCATE TABLE lines, and adding REPLACE at the start of the INTO TABLE lines. This way you should just be able to add/update rows without having to replace the whole tables, but I haven't tried this yet.

[Guest ByondF1]

Thanx. I will give it a shot.

[Guest estelle]

No worries . Goodluck.