Sql

[Guest becky]

I want to upload my cvs file to MySql. I have a program to do it, but I need to know what the format of the columns are.

I have looked at the file CubeCart makes for Froogle

Product URL

Name

Description

Price

Image Url

Category

Offer ID.

Is this the same order each Excel column would be for uploading?

I am not sure if I need to change the columns around like if I were to upload to Shopzilla.

Thank You,

Becky :)

[markscarts]

Hi Becky,

This probably won't help much. I do not know alot about the database, and I think taht what you are asking will depend on which program you have to upload his stuff with. The program I have used allows you to pair up columns in your csv with fields in the database table you are updating, so the order of your csv fields in your file doesn't really matter.

Anyway, here are the fields in your "CubeCart_inventory" table:

productCode: varchar(60)

quantity: int(16)

description: text

image: varchar(250)

noImages: int(11)

price: decimal(30,2)

name: varchar(250)

cat_id: int(16)

popularity: bigint(64)

sale_price: decimal(30,2)

stock_level: int(11)

useStockLevel: int(11)

digital: int(11)

digitalDir: varchar(255)

prodWeight: decimal(10,2)

taxType: int(11)

showFeatured: int(11)

And here are the fields in you "CubeCart_category" table:

cat_name: text

cat_father_id: int(16)

cat_image: varchar(250)

per_ship: decimal(20,2)

item_ship: decimal(20,2)

item_int_ship: decimal(20,2)

per_int_ship: decimal(20,2)

noProducts: int(11)

Maybe that will help?

[Guest becky]

Thank You MarksCarts,

You explained it well.

I just was confused because when I feed files to Shopzilla and Froogle the columns have to be rearranged. So, I thought maybe I needed to rearrange the columns in my spreadsheet and didn't know what field a, b, c and so on were.

I believe that the program you and I are using is the same one, so I should be able to pair up the columns as you mentions. :)

[markscarts]

No prob, Becky, good luck!

BTW, I just realized that I messed up my original post and listed the CubeCart_category fields twice

I have edited it now so the the CubeCart_inventory table fields are correct ;)