eBay Turbo Lister 2.0 Exporter Support Thread

The upgrade only needs to be run if you are upgrading. For a first time installation just run the install.sql/ebay.sql (can't remember what I named it).

eBay Turbo Lister 2.0 Exporter v.0.9.6 29.08.2007 13:40 started 2007/10/05 07:54:20
Feed file - /home/addisc5/public_html/feed/ebay.csv
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]

Got an error but not sure what it means please help

got my file exported now when i try to import it into turbo lister it freezes..

Ok i uploaded a piece of the file and it worked

But

1. There isn't any Weights for any items
2. the categorys in ebay are blank
3. The shipping calculaters aren't selected.
4. the store category is just listed in other..

Hi guys

I want to sart selling my items in ebay and i'm not sure what add on should I use... I found this one, the eBAY Turbo Lister and there is Auction Lister Pro (http://www.zen-cart.com/forum/showthread.php?t=71781&highlight=ebay&page=11)

Can anyone tell my what is the difference between them? which one is ready to use? which one works better?

Thank you for your help and for this great contribute
You are great:clap::clap:

Auction Lister Pro is a work in progress but allows you to list a single product at a time to eBay. You can create separate item templates etc. In the future I will make lists etc. It will also have email checkout and checkout redirect. The end result of ALP is to have eBay users checking out directly on your cart instead of double handing paperwork between PayPal etc. The only downside to ALP is that it is HUGE and requires a very good hosting account. The eBay API library makes it that way. ALP will not run on an inexpensive account GoDaddy etc.

This contribution however lets you dump your inventory to Turbo Lister to put items on eBay. This is fine for small lists but as they start growing the sync times in Turbo Lister will get slower and slower.

If you need to sell a bunch of stuff right now then you would want to use this mod I presume. Turbo Lister is fairly quick up until the 500 item mark from my testing and experience. But I don't have the fastest computers in the world either. Some have said it starts slowing down between 1000-2000 items. Your mileage may vary.

The purpose of both mods are the same, get your products on eBay. You may want to use this until ALP has matured a little more and includes bulk listing.

What did you do to fix this problem?

Dashizna:

eBay Turbo Lister 2.0 Exporter v.0.9.6 29.08.2007 13:40 started 2007/10/05 07:54:20
Feed file - /home/addisc5/public_html/feed/ebay.csv
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]

Got an error but not sure what it means please help

Either install ASA or turn it off.

are you talking to me? if so what is ASA or turn what off?

numinix:

Either install ASA or turn it off.

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.

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]

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??

Try this file.

Extract to store's root.

numinix:

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??

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

numinix:

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.

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

If so I will include it in v0.99.

numinix:

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

email your feed file to [email protected]. 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).

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

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?