Uploading items from .csv file?

[igavemybest]

Is there instruction anywhere on how to do this?

[AlexG]

Is there instruction anywhere on how to do this?

I've made the converter from csv to xml because csv import has not all fields than xml.

[mazhar]

Is there instruction anywhere on how to do this?

DataPort utility is used for CSV and XML uploads.
Please read the following WIKI topic to learn more about DataPort Utility.
http://wiki.ablecommerce.com/index.php/ ... rt_Utility

[igavemybest]

Is there instruction anywhere on how to do this?

I've made the converter from csv to xml because csv import has not all fields than xml.

Could you tell me about this? Or does the sataport utility work better or easier?

[igavemybest]

I do not know how to get the dataport to work with my CSV file. I have items, each with a main category and 3 subcategories. Isn't there a way to do this where the items are put in the respective categories automatically, and if it is the same categrory name it knows "hey, this category name, and subcategory are the same, so I dont hav eto create it again.. so the product goes here!" Any suggestions, tips comments? Please?! I was trying to attach my .CSV file so you can see what I am talking about, but I am not allowed to upload a csv file to the forum for some crazy reason. I even changed the extension to aspx and it still wouldnt let me upload. Sorry. Here is an idea from a the file:


Part Number,Prefix,Brand Name,Item Description,SKU,Minimum Selling Quantity,Minimum Order Quantity,Multiples Required,Sold in Std. Pkg.,Std. Pkg. UOM,Std. Pkg. Quantity,Price Unit,Package,Price Date,Reference Price Type,List Price,Your ORS Nasco Cost,Level 1 Customized,Minimum Qty for Level 1,Your Promo Cost,Promo Sell Price,Promo Start Date,Promo End Date,Promo Flag,Price Change,Closeout Flag,Volume Discount Flag,Item Discount,Product Group,Item Weight,Item Height,Item Width,Item Length,Item Cube,UPC Code,UNSPSC Code,Country of Origin,HAZMAT Item,ANSI Stock UOM Code,ANSI pricing or selling UOM Code,ANSI Std. Pkg UOM Code,Stocked Birmingham,Stocked Harrisburg,Stocked Houston,Stocked Jacksonville,Stocked Muskogee,Stocked South Bend,Stocked St. Paul,Stocked Visalia,Brand Catalog Page #,Bg Catalog Page #,Construction Catalog Page #,Industrial Catalog Page #,Janitorial Catalog Page #,Most Popular Items Catalog Page #,Oilfield Catalog Page #,Rental Catalog Page #,Safety Catalog Page #,Welding Catalog Page #,Product Category,Product Sub-Category

405-021200-02983,405,3M ABRASIVE,SCOTCH GENERAL PURP.MASKING TAPE 234 NAT 36MMX55,ROL,1,1,N,N,CS,24,ROL,24ROL/CS,9/1/2008,MFG LIST,8.15,5.705,6.846,1,0,0, / / , / / ,,B,,,Mfg List Less 30%,"3M Abrasives, Adhesives, and Tapes",0,0,0,0,0,21200029832,31211903,,N,RL,RL,CA,G,G,G,G,G,G,G,G,,,,,,,,,,,Abrasives,Abrasives Other