Jump to content
Sign in to follow this  
Peper

CSV sample to database to admin options

Recommended Posts

Hi everyone

 

Is it possible to take a CSV file for bulk uploading products to other stores and implement it inside the admin panel??

 

Currently I'm using a addon by bidorbuy to make an xml product list with description, pricing and image, but lacks half the information to list products through admin, it e.g. lacks guarantee, warranty options and product attributes mainly (many more but yes..)

 

So in essence: CSV tables be worked into admin and then use to xml export?

 

Sample xml currently on my side when generated

<Product>
<ProductCode><![CDATA[ new10 ]]></ProductCode>

<Title><![CDATA[ Printer x1000 ]]></Title>
<Category><![CDATA[ 1535]]></Category>
<Price>400.00</Price>
<Quantity>200</Quantity>
<Condition>New</Condition>
<Location></Location>
<ShippingOption><![CDATA[ DefaultShipping ]]></ShippingOption>
<ImageURL><![CDATA[ http://shop.com//images/111.jpg ]]></ImageURL>
<Description><![CDATA[ Products description ]]></Description>
</Product>

 

 

CSV sample:

"Listing Type [mandatory] ENGLISH_AUCTION or FIXED_PRICE or CLASSIFIED_CONTACT","TITLE [Text Title for Item - Max 100 chars] ","Primary Category [mandatory Number]","Secondary Category [optional Number - Incurs a Fee]","Traders Reference [optional Max 100 chars]","Start Date/Time [mandatory Date dd/mm/yyyy HH:mm]","Stop Date/Time [mandatory Date dd/mm/yyyy HH:mm]","Number of Items [mandatory Number]","Number of Items Per Lot [optional Number]","Auction Starting Bid Amount [mandatory for auctions Currency 0.00]","Auction Bid Increment  [mandatory for auctions - specify an amount in decimal format. Currency 0.00]","Auction Reserve Amount [optional only for auctions Currency 0.00]","Fixed Price (Buy Now Price) [mandatory field for Buy Now items Currency 0.00]","Recommended Retail Price [optional Currency 0.00]","Currency [mandatory R for ZAR] R","Item Condition [mandatory] ""NEW"" or ""SECOND_HAND"" or ""REFURBISHED""","Image URL [optional but recommended URL http://www]","Auto Re-list Options [optional]   RELIST_DAILY or RELIST_IMMEDIATELY or RELIST_DAILY_ALL or RELIST_IMMEDIATELY_ALL","Number of Auto Relists [optional Number] The number of times to relist, if relisting is specified by the previous column","Item Description [optional but recommended Max 8000 chars] Text or html description of the item for sale. html descriptions can provide attractive and sophisticated descriptions including additional images using html tags such as <img src="http://www.somedomain.com/images/item1.gif">","Discreet Listing [optional] ""yes"" or """"","Home Page Featured Listing [optional - Incurs a Fee] ""yes"" or """"","Category Page Featured Listing [optional - Incurs a Fee] ""yes"" or """"","Priority Listing [optional - Incurs a Fee] ""yes"" or """"","Highlighted Listing [optional - Incurs a Fee] ""yes"" or """"","Promotional Listing [optional - Incurs a Fee] ""yes"" or """"","Premium Listings [optional - Incurs a Fee] ""yes"" or """"","Verified Buyers Only [optional] ""yes"" or """"","Warranty Type [optional] """" or ""NOT_OFFERED"" or ""REPLACEMENT"" or ""DEALER"" or ""MANUFACTURER""","Warranty Remarks [optional Max 300 chars]","Guarantee Type [optional Number] ""0""=Not Offered or ""7""=Money-Back 7 Days or ""10""=Money-Back 10 Days or ""15""=Money-Back 15 Days or ""30""=Money-Back 30 Days or ""1007""=Replacement 7 Days or ""1010""=Replacement 10 Days or ""1015""=Replacement 15 Days or ""1030""=Replacement 30 Days","Guarantee Remarks [optional Max 300 chars]","Prompts [optional]","Shipping Option [optional]","Automatic Extension Minutes [not available for most users blank or the number 1]","End of Record [mandatory] set to 'End'"
"FIXED_PRICE","Buy Now:  Simple Example Item 2 (One Image)",2521,,"NR0401","30/08/2010 16:00","13/09/2010 16:00",50,,,,,7200,11900,"R","NEW","http://www.bidorbuy.co.za/images/imageupload/10048313/21770787.gif","RELIST_DAILY",1,"<p><font face=""Arial"" color=""#0000ff"" size=""5""><strong>Title Here </strong></font></p><p> </p><p>General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb</p><p> </p><center><img alt="""" src=""http://www.bidorbuy.co.za/images/promo/bulkload/0prettygirl.jpg"" /> </center><p><strong>Punch Line! </strong></p><p><font color=""#ff0000""><big>Retail Value: R xxx.xx </big></font></p>","yes","yes",,,"yes",,"yes",,,,1007,"We stand by this gurantee",,,1,"End"
"ENGLISH_AUCTION ","Auction:  Simple Example Item 2 (One Image)",2553,1270,,"31/08/2010 12:00","01/09/2010 20:00",50,10,1,500,,,14500,"R","REFURBISHED","http://www.bidorbuy.co.za/images/vendors/festivals/nature/284/54earrfinal.jpg","RELIST_IMMEDIATELY_ALL",3,"<p><font face=""Arial"" color=""#0000ff"" size=""5""><strong>Title Here </strong></font></p><p> </p><p>General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb General blurb</p><p> </p><center><img alt="""" src=""http://www.bidorbuy.co.za/images/promo/bulkload/0prettygirl.jpg"" /> </center><p><strong>Punch Line! </strong></p><p><font color=""#ff0000""><big>Retail Value: R xxx.xx </big></font></p>",,,"yes","yes",,"yes",,"yes","DEALER","all out products receive a warranty",15,"We stand by this gurantee",,,,"End"
"CLASSIFIED_CONTACT","Classified: Example Item 1 (Multiple Images)",632,,,"30/08/2010 16:00","13/09/2010 16:00",2,,,,,13000,,"R","SECOND_HAND","http://www.bidorbuy.co.za/images/vendors/festivals/nature/284/54earrfinal.jpg",,,"<p><font face=""Geneva, Arial"" color=""#993300"" size=""5"">Mitsubishi Outlander Demo Model Selling At A Bargain Price</font></p><p align=""center""><img align=""absMiddle"" border=""0"" alt="""" src=""http://www.bidorbuy.co.za/images/promo/bulkload/0Outlander3.jpg"" /></p><p><font size=""4""><strong>Make</strong>: Mitsubishi</font></p><p><font size=""4""><strong>Model</strong>: Outlander</font></p><p><font size=""4""><strong>Year</strong>: 2004</font></p><p><font size=""4""><strong>Mileage</strong>: 12,000km</font></p><p><font size=""3"">The Outlander is powerful proof that Mitsubishi isn't afraid to break the rules. Who says you can't couple the ride comfort and engineering precision of a sedan with the versatility and sense of adventure of an SUV? The Outlander offers a compelling combination of both. Luxuries include a 210-watt, 6-speaker Mitsubishi/Infinity? 6-CD/MP3-capable audio system, leather seating surfaces and a one-touch power sunroof. Outlander's spacious interior features 60/40 split-folding rear seats, a generous amount of cargo room and low tailgate height (under 31 inches) that makes loading and unloading a snap. And since it can seat five adults comfortably, Outlander is always ready to go, whether you're driving cross-country or just across town. </font></p><p align=""center""> </p><p align=""center""><img align=""absMiddle"" border=""0"" alt="""" src=""http://www.bidorbuy.co.za/user_images/102/0OUTLANDER.jpg"" /></p><p align=""center""> </p><p align=""center""><img align=""absMiddle"" border=""0"" alt="""" src=""http://www.bidorbuy.co.za/user_images/002/100OutlanderDash2.jpg"" /></p><p align=""center"">To find out more about this vechicle please contact me:<br />Candice Meyer<br />Tel: 011 706 5771<br />Mitsubishi Motors</p><p align=""center""><img align=""absMiddle"" border=""0"" alt="""" src=""http://www.bidorbuy.co.za/user_images/002/100Bernie.jpg"" /></p><p align=""center""> </p>",,,,,,,,,,,,,,,,"End"

 

Any suggestions please


Getting the Phoenix off the ground

Share this post


Link to post
Share on other sites
Is it possible to take a CSV file for bulk uploading products to other stores and implement it inside the admin panel??

yes, it's possible. several modules available from contribution area.

 

Sample xml currently on my side when generated

it's very easy to update your current export script to able to export in CVS instead of XML


Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Share this post


Link to post
Share on other sites
it's very easy to update your current export script to able to export in CVS instead of XML

 

Thanks for reply

 

I require xml for the auto update of my shop products to bidorbuy which is not osCommerce, however the sample CSV - too complicated and manually updating a couple of hundred products

By using the xml, my products etc. is automatically updated once per day

 

Basically, taken the sample CVS posted, can I make my existing admin export(admin/bidorbuy.php) which is incomplete by lacking additional options, add export options as required or available by the CVS sample to output similar to sample xml(catalog/bidorbuy.php) + options indicated by CSV.

 

(:huh: Myself got confused there for a second)

 

I guess it would be far fetched with a couple of database changes as it got it's own bidorbuy table, I'm not that good with php

 

Any direction as nothing like this is documented on the net

 

Thanks in advance


Getting the Phoenix off the ground

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×