Best Method of Importing?

[AngstyG]

I'm setting up a new store, and all this attribute stuff is making my head spin. I think I get the gist, but I'm wondering if there's any way to do this in bulk, since I already have a spreadsheet of every product.

The store is clothing retail, and all my products are already broken down to one row each per size and color. So I figure that helps? But I looked into the EasyPopulate, and it won't let me add attributes via my spreadsheet (at least, it doesn't appear so), so am I stuck having to add each attribute manually, or is there a better way I haven't come across yet?

A normal product for my store goes like:

Item Number,
Item Title,
Item Category,
Item Sub-Category,
Item Desc,
Item Image,
Item Style#,
Item Color,
Item Size.

Ahhh, any help is appreciated! My brain hurts. I'm sure there's a thread or something floating around with a similar query, but I didn't find anything.

Thanks!

[AngstyG]

Found this add-on for XLSX Import/Export: osCommerce Community Add-Ons But not sure what it does. It doesn't really say? And I don't see an example spreadsheet anywheres

[ridexbuilder]

I do hope that you are NOT using osCmax 1.7 !!!!!

Create a product with attributes; export using EP, having first upgraded to at least version 'i' and turned on the attribute flag; import the (tab delimited to be safe) CSV into OpenOffice; modify the relevant attributes (0 means a non-price-affected attribute); import using EP.

osCmax 2.0.25 SVN and osCmax 2.5 Beta 1 both have the upgraded EP already installed, along with the standard contribution documentation.

EJ

[AngstyG]

Yikes! I'm totally using 1.7

Instant No Button! Star Wars funnies FTW!

"Create a product with attributes; export using EP, having first upgraded to at least version 'i' and turned on the attribute flag; import the (tab delimited to be safe) CSV into OpenOffice; modify the relevant attributes (0 means a non-price-affected attribute); import using EP."

So is this for 1.7 or the new 2.0/2.5? I think I'll just upgrade now, since I'm just starting out.

Thanks for the help! A lot of that was like Latin to me, but I'll do some digging. You're winsauce.