Uploading items from .csv file?
Posted: Thu Sep 25, 2008 10:55 pm
by igavemybest
Is there instruction anywhere on how to do this?
Re: Uploading items from .csv file?
Posted: Thu Sep 25, 2008 11:34 pm
by AlexG
igavemybest wrote: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.
Re: Uploading items from .csv file?
Posted: Fri Sep 26, 2008 5:37 am
by igavemybest
AlexG wrote:igavemybest wrote: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?
Re: Uploading items from .csv file?
Posted: Fri Sep 26, 2008 6:09 pm
by 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