CSV datafeeds

[drivetowin]

Tweet

Is it just me or can anyone actually access any csv data - I can download data for almost all merchants using the XML feed but all the csv ones return no data.

[madstock]

Alas no, I have experienced the same ...

Duncan
--
http://www.shopmadstock.com

[Rich]

Me too, and the XML has invalid affiliate links for me (no AID). I've posted to the datafeed support site (linked off the IPS menu on AW) and am waiting for a response.

I'm not in a great rush so haven't emailed support.

[drivetowin]

The XML feed in zip files has been without affiliate IDs for quite a while, you have to add them in yourself - pain pain pain

[999gi]

Where do you download them from - I havent found this
(somewhere obvious no doubt)

[Jeff]

Originally posted by 999gi
Where do you download them from - I havent found this
(somewhere obvious no doubt)

You have to tell Marc you want to receive the csv datafeeds, and he'll email you with instructions on how to get them.

[Elaine]

I know XML is a type of code, but what exactly is CSV?

[ianm]

Originally posted by Elaine
I know XML is a type of code, but what exactly is CSV?

Comma Separated Values - it's a text file with the individual fields separated by commas.

They can easily be loaded into Excel or a MySQL database.

[drivetowin]

Marc / someone at AW

Can we have an answer on when CSV files will be available soon?

[Marc Gear]

Most of the CSV files should be availiable now, the problem was due to an oversight in how the data is regenerated and is fixed now.

Sorry guys.

[999gi]

I keep emailing you Marc about this but dont seem to be getting a reply. First was last wednesday. Are you way behind on your emails?

[drivetowin]

Still doesn't seem to be working....

[Jeff]

Originally posted by Marc Gear
Most of the CSV files should be availiable now, the problem was due to an oversight in how the data is regenerated and is fixed now.

Sorry guys.

I've been trying to download a lot of csv files tonight, and less than half of them are working.
The rest are giving me a 'This merchant currently has no products in our system.' message.

Is there a list of the merchants with csv files, so we don't waste time trying to get files that don't exist?

[Jeff]

To answer my own question:

I've not signed up to all the product feed enabled merchants, but of those that I've tried, the following merchants csv files contain product data:

Crotchet Partner Program
24-7 Electrical
JustPhones
Electricshock
Empire Direct
OutdoorGear UK
Prism Direct
Prezzybox
Mobiles
Tribal UK
Hatton Garden Online
TheDrinkShop
Oddbins
Greenfingers Trading Ltd
Micro Warehouse
Sportzwear - discount branded clothing
Buyagift.co.uk
ExtremePie
Jason Shankey Mail Order
Budget Batteries
LetsGoRetro
agirlsworld
Gadgets
Mr Office
Enjoy.co.uk
Pickamobile
JewelleryNow
Needapresent
Chocolate Trading Company
CasaRosaFlorists
Gadgets UK
Mytights
DVD Players UK
e2save
Direct Electrical
The MobileOutlet
E-Factory Deals
Premier Direct UK Ltd
Alpsweek
Latest Events
Pharmacy2U
DontForgetYourCard
Your Price Furniture
Garden Pharmacy



The following IPS enabled merchants do not have any csv product data:


DrinkStuff
Fragrancedirect
CD-Wow
Lingerie-Confidential
eLingerie.uk.net
Mexicana
Laden
Holisticshop
FragranceBay
TSF1
StudentBookWorld
CX LONDON
Blushingbuyer
Phones 2 U Direct
1st Vitality
Boystuff Ltd
Tightsplease
Advanced MP3 Players
I Have To Have It!
Be Direct
Ancestral Collections
Key TV
Cloggs
Perfuma
Top Brands Direct
Voodoo Shoes
Euroffice
Heavenly Bodice
Designer Sales Direct
Yves Rocher
WinPure
Frozen Clothing
Miskis
Ink4Europe
Bliss gifts
Magellan´s International Travel Inc
Beau Blue
wonderfulbuys
Wildlife
Tooled Up
CCCDirect
Diamonds Are
Pure Vacations Ltd
123 Jewellery
Ultimate Dream Days
Gameseek
B & Q


The two merchants I'm particularly interested in getting product data from are CD-Wow and B&Q, who are both on the 'no products' list

[drivetowin]

Wow!! Thanks for the list - at least I know which ones I can get started with..... I must confess I only tried 3 (all on your no data list!) and gave up.


Marc - can the rest be done asap - as you already hold all the data in XML it is presumably only a case of running some sort of application (alternatively for a fee I've got an application that does the job which I've been using up until now - though it is a bit labour intensive as you need to do a find and replace to swap out any delimiters first.