Feed not importing products

Submitted by allanch on Tue, 2012-10-09 11:26 in Price Tapestry

Hi David,

I hope you're well. I have a feed which is producing sample data in all the relevant fields, but when I press the 'Register' and 'Register and Trial Import' buttons no products appear. I have quite a few other Affiliate Window CSV feeds which are all working fine. I've checked I have the right field names selected and I have also put the file into the Magic Parser online demo and it comes fine with data in the right fields. Do you have any advice on what may be causing the problem? Thanks.

Allan

Hi Allan, I just upload a

Submitted by support on Tue, 2012-10-09 12:13

Hi Allan,

I just upload a feed analysis tool that I created recently which performs a simulated import against registered feeds and displays the results in terms of number of records dropped (and for what reason) as well as the number of duplicate products in the feed.

Download Analyser.zip, unzip and upload the file analyser.php to your /admin/ folder and then browse to /admin/analyser.php. To use, simply select the feed that you wish to analyse and submit the form.

If you're still not sure from the output where the problem lies let me know and I'll investigate further for you...

Cheers,
David.
--
PriceTapestry.com

Hi David, thanks for the

Submitted by allanch on Tue, 2012-10-09 17:18

Hi David, thanks for the speedy reply as always. I've used the analyser and the only error that comes up is 6 duplicate values. Do you think it could be this? I tried analysing other good feeds and they have duplicate values too but everything works for them. Thanks.

Hi, Please could you post a

Submitted by support on Wed, 2012-10-10 07:18

Hi,

Please could you post a link to your installation and the filename of the feed (i'll remove before publishing your reply) and I'll download the feed to my test server and check it out for you...

Cheers,
David.
--
PriceTapestry.com

Thanks David, its at {link

Submitted by allanch on Wed, 2012-10-10 09:11

Thanks David, its at {link saved} . The file is a biggie at 82M but I have managed to use in the past.

Hi Allan, Downloaded and

Submitted by support on Wed, 2012-10-10 10:46

Hi Allan,

Downloaded and registered / imported fine (i'm afraid!). Can you confirm on your installation first of all the format auto-detected as csv|124|1|34 and then on Feed Registration Step 2 fields mapped as follows:

Product Name: product_name
Description: description
Image URL: merchant_image_url
Buy URL: aw_deep_link
Price: search_price

Category: merchant_category
Brand: brand_name

If that all looks good and still nothing imported let me know and I'll investigate further...

Cheers,
David.
--
PriceTapestry.com

Hi David, thanks for

Submitted by allanch on Wed, 2012-10-10 11:20

Hi David, thanks for checking this. I am getting csv|124|1|34 and they fields are autodetecting. I have three other fields delivery_time, delivery_cost and in_stock which exist in database and work fine with other feeds. I'll double check the database fields again. Thanks

Hi Allan, Don't forget that

Submitted by support on Wed, 2012-10-10 11:26

Hi Allan,

Don't forget that you can enable database debug mode by changing line 6 of config.advanced.php as follows;

$config_databaseDebugMode = TRUE;

That may reveal something if you have custom fields / code going on during import - again let me know if you're still not sure...

All the best,
David.
--
PriceTapestry.com

Thanks David, I'll try that.

Submitted by allanch on Wed, 2012-10-10 12:01

Thanks David, I'll try that. I do have other feeds where the custom fields have been imported without any problems.

Hi David, managed to track

Submitted by allanch on Thu, 2012-10-11 07:31

Hi David, managed to track the problem to a global filter which meant that nothing was being imported due to it. Thanks for your help as always!