eBay Turbo Lister 2.0 Exporter Support Thread

[dealbyethan.com]

Hi, I get the same error message when trying to create/update product feed. The ASA is already set to off. What did I do wrong? Please advise. Thanks in advance.

1054 Unknown column 'p.products_ebay' in 'field list'
in:
[SELECT p.products_id, p.products_model, p.products_weight, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, s.specials_new_products_price, s.expires_date, p.products_ebay, products_length, products_width, products_height, products_upc, products_weight_type, products_dim_type, products_phrases FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) LEFT JOIN zen_specials s ON (s.products_id = p.products_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_id ASC]

[YairOz]

Hey Guys

I've just installed ebay_exporter_v0.98 and asa_v1.07.

I created a new csv but when it being exported to Turbo Lister (downloaded from ebay website) it doesn't work.

No details in the products, no title, no description, nothing....

I think the only thing that is being exported good is the pics - I can see the url path for the pics under "Custom Label" in Turbo Lister.

Anyway I checked the file in excel and it looks fine....

Anyone have any ideas??

[numinix]

Try this file.

Extract to store's root.

[YairOz]

Try this file.

Extract to store's root.

Thanks for the fast replay

im got this error while trying to process a new file:

Parse error: syntax error, unexpected '=' in /home/academyf/public_html/ebay.php on line 254

So i edited it and added another = (I another line like this with two == and this one had one only...)

The file processed fine but it still the same....

I noticed something else, when the turbo lister procesing my file it says that I have like 29000 Items although I have only 328. In the end it says that only 328 items had been listed...

What do i do wrong??

[lextechs]

I am guessing it's the lastest version i downloaded it from the zencart download area, it seem that i am not the only one with the problem

Auction Site Attributes

It's off by default I believe in the configuration of each feeder/exporter. The latest version was supposed to fix that bug, but if you are using the latest version, and ASA is set to false, then I will have to see if I missed some code.

[numinix]

I only need to know if the patched file above fixes the problem...

If so I will include it in v0.99.

[YairOz]

I only need to know if the patched file above fixes the problem...

If so I will include it in v0.99.

No it didn't worked... I still can't see my products details in ebay's software...

do u have any other solution...??

thanx for helping

[numinix]

email your feed file to webmaster AT numinix DOT com. The amount of time I can spend on troubleshooting these issues for each script is limited...

Also, I was speaking to the poster above to please test the patched file for the issue of the unknown column p.products_ebay (which is a field added by ASA).

[batteryman]

Hello Numinix,

This may seem a little anal but I got your new mod which I am in the middle of testing, but saw the graphic was in need of a little TLC so I made you another logo for your mod. I made it in PNG format though because it comes out much cleaner with the transparent background. Hope this helps. Just edited with the correct dimensions to prevent any stretching

I am really excited to see this mod in action because I was about to begin to attempt the same thing. So im glad you made it first and saved me headaches, hair and sleep.

thank you,
avel

[batteryman]

Hello,

I have the mod installed and the options set and I ran the file generator and keep getting these errors

1.

Processing: Feed - Yes, Upload - No
1054 Unknown column 'p.products_ebay' in 'field list'
in:
[SELECT p.products_id, p.products_model, p.products_weight, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, s.specials_new_products_price, s.expires_date, p.products_ebay, products_length, products_width, products_height, products_upc, products_weight_type, products_dim_type, products_phrases FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) LEFT JOIN zen_specials s ON (s.products_id = p.products_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_id ASC]

And on my website I get these errors on the top of the page

Warning: Variable passed to each() is not an array or object in /home/batte9/public_html/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/batte9/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/batte9/public_html/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/batte9/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/batte9/public_html/includes/init_includes/init_templates.php on line 78

What can it be. I have your 2 other modules installed. Google Feeder and LPS Feeder. Could these 3 be conflicting with each other?