HomeHome Product Discus... Product Discus...SmithCartSmithCartFroogle / Amazon / XML Export?Froogle / Amazon / XML Export?
Previous
 
Next
New Post
7/13/2010 4:47 AM
 

I their any way within SmithCart to create an XML, CSV or TSV file to send to Froogle and/or Amazon as I would really like to use Smith Cart to drive product details etc into these other services.

 
New Post
7/15/2010 4:02 PM
 

I would like to know about this as well...

 
New Post
7/16/2010 5:18 PM
 

Currently there is not a Froogle/Amazon xml productexport. The cart has an order export function and also USPS and Endicia exports but those export orders. Can you post a link to the Froogle/Amazon xml specs so we can look into how long it would take to program.

Thanks,

Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
7/17/2010 6:16 PM
 

I can get the froogle/amazon format for you but would like to suggest a better option. Their are a growing number of different feeds that people would like to use that have an XML import function and it will be hard to keep getting you guys to write a new export. So what I would like to suggest is the following. You create a generic XML export function for the product table which has a textbox for opening XML and another for closing XML. Then you have a repeat / item textbox which the use can fill in. Then you list all of the fields in the products table that can be used for exporting and next to each field you have a tag textbox to enable the user to enter the XML tag which you would use the opening and closing of each field within the repeating section. If the user does not enter a value in the textbox the field does not get exported. You also allow each XML export to be saved so that users can have multiple exports eg ebay, froogle, amazon, play, price comparison sites etc. This would be easy for you guys to code and would mean you dont have to keep writing new XML exports. Ideally their should be an option to be able to download and upload formats so users on your forum and yourself could provide preformatted XML export solutions which would enable your products XML export ability to grow quickly from users creating them for you. If I havent explained that very well I would be happy to put a plan together for you showing exactly what I mean in more detail with some diagrams but this may take a few days.

 
New Post
7/19/2010 10:55 AM
 

I agree with your idea of a generic product xml export so the cart is not tied to any particular spec that will probably change at some point in the future anyway! Less maintenance is always a good thing. Thanks for your feedback, I will add this to the dev list.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
6/5/2011 8:37 AM
 

A rough way to export all products is go to the Host/SQL screen, and enter:

select ProductID, ModelNumber, ModelName, DownloadUrl from Smith_Products

Copy the output, paste to a text editor. Use search/replace, or write some code to wrap the data with the necessary XML tags.

To see all the columns available, do:

select column_name, data_type from information_schema.columns where table_name='Smith_Products'
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartFroogle / Amazon / XML Export?Froogle / Amazon / XML Export?