products database structure? How to?

[robertm18]

Zen Cart 1.3.9h
Easy Populate 1.3.5.4

Having trouble importing a tab delimited text file catalog.

I did one mod to a standard zen cart: ALTER TABLE products ADD `products_msrp` DECIMAL ( 15, 4 ) NOT NULL AFTER `products_price` ;

Tried the import with all fields downloaded from easy populate, and also with adding v_products_msrp before v_products_price.

Note: many of my fields contain no data.

Questions:

When creating the text file, must all the fields be represented in the text file, or may one use only the fields that are to be imported?

Is there a way to display the database structure so that I can check that all the fields are represented in my text file?

Is there a way to see where the import is bombing? It looks like I get about half way through the upload of the first record before it crashes. I get 1 record created and a bunch of pipes and data after that, greyed out.

Thanks for any insight anyone can offer! New to both Zen Cart and EP, so thanks for understanding.

Rob

[kobra]

EP keeys on the model number so one must have a model number assigned

There is a wiki article on how yo use

[robertm18]

EP keeys on the model number so one must have a model number assigned

I have completely clean products database. No products at all.

[kobra]

I have completely clean products database. No products at all.

Create a couple so that when you download you will have a structure

See the wiki article

[robertm18]

Create a couple so that when you download you will have a structure

Thanks! I will try that. Re-reading the wiki once again.

[robertm18]

Resolved

Two issues. A couple of my field names had a preceeding space and no EOFEOF after each record.

Thanks for your help.