Problems with iwantoneofthose, dot2shop and iwantitcheaper datafeeds?!@*

[DanielCoe]

Tweet

Hi,

I have just started using the DGM product feeds from:

Dot2Shop
iwantoneofthose
iwantitcheaper

But it appears, all is not well.

Dot2Shop do not appear to have any links working at all.

iwantoneofthose product feed xls contains loads of stock they just don't carry anymore.

iwantitcheaper also don't carry some stock and also they have some errors with their SQL statements when trying to visit a link.

An error example is listed below:

There was a fatal error in the SQL Statement.
Error number: -2147217900
Error Description: Incorrect syntax near the keyword 'FROM'.
Error Source: Microsoft OLE DB Provider for SQL Server
SQL State: 42000
Native Error: 156
SQL: SELECT DISTINCT FROM WHERE (products.clientID = 17) AND AND (NOT (products.ProductId IS NULL)) ORDER BY

Even I know you can't have 2 'AND' statements together!

Has anybody else had the same problems?

Can someone from the companies comment?

I'll also let DGM know.

Thanks

Daniel

[DanielCoe]

Apparently,

Dot2Shop feed has now been removed, and the other two are getting updated soon.

Thanks, DGM for your quick response.

Daniel

[999gi]

I wouldnt call what DGM offer "feeds" in the same sense as what is available on other networks. Its more just a load of spreadsheets ranging from 1-20 weeks old.