eBay Turbo Lister 2.0 Exporter Support Thread

[BlessIsaacola]

Think I've got a fix for this:

change line 645 in ebay.php from

$output = rtrim($output) . "\n"; 

to

$output = rtrim($output) . "\r\n"; 

this seems to work for me and i can now import the file directly into turbo lister

I have problem with the output file generated but the above fix doesn't work for me. I use ebay turbo lister exporter, yahoo product submit, google base and live product search. This is the only mod (eBay Turbo Lister) that I am having problem with the output.

My issues is the description field includes some strange character that I cannot simply find and replace. The character is a square box that is inserted into some description which causes Turbo Lister to not import. IF I manually delete the squares everything works.

I am wondering if there is away to strip the output of these squares, I am not sure if it's related to extra tabs or a return carriage problem as describes in previous post.

I am also not sure if this have anything to do with this:

$output = rtrim($output) . "\r\n";
            /*if(strtolower(CHARSET) != 'utf-8')
                $output_buffer .= utf8_encode($output);
            else
                $output_buffer .= $output;*/ 

Our charset=iso-8859-1 so I am not sure if there is something that needs to be done different with the above code.

Please help as I do not want to go through 1,000s of description fields to manually delete the square boxes.

Thanks!

[numinix]

Isaac,

You may have found something. Try removing the /* */ around that section and let me know if that changes anything. Your descriptions might look different, but at least they'll import.

[BlessIsaacola]

Isaac,

You may have found something. Try removing the /* */ around that section and let me know if that changes anything. Your descriptions might look different, but at least they'll import.

Thanks Jeff for the prompt response. Removing this:

/*if(strtolower(CHARSET) != 'utf-8')
                $output_buffer .= utf8_encode($output);
            else
                $output_buffer .= $output;*/ 

does not solve the problem. That's line 640-643 of /public_html/ebay.php. I just want to make sure that I am removing the right lines.

Thanks!

[numinix]

Don't remove the entire section, it's already commented out. Just remove the /* and the */ from the beginning and end and that portion of the code will become active again.

if(strtolower(CHARSET) != 'utf-8') 
  $output_buffer .= utf8_encode($output); 
else 
  $output_buffer .= $output; 

[yellow1912]

numinix, can I do something like this with this mod:

On my site the product price is 9.99. S&H is 2.95
When list on Ebay, I want to list the price as .99, and S&H is 11.5 (just an example)

This is the way many ebayers do to:
!. Avoid the high charge from Ebay
2. Get higher ranking on search (ebay lists cheapest items first)

Maybe something like this: allow user to set desired price on ebay, the the S&H will be total - SH for example?
Or maybe just let the user set the desired SH and price, which would be applied for all products within a price range?
Regards,
yellow1912

[numinix]

Hmm, I will add that option in a later version. However, I will say, use at your own risk as eBay does state that it will ban users if it finds that they are using inflated shipping rates to avoid fees.

The other thing is, does the eBay module even export shipping information? At this time I'm unsure if I have updated it to use Auction Site Attributes shipping rates. So, if you just set the FIXED_PRICE to be 0.99, then you can just manually add the shipping rates after.

I apologize that I am falling behind in updating a lot of the scripts with features I originally planned to include. The eBay script I believe is lacking in this the most because of the high number of attributes it supports. The problem is Turbo Lister II is not the greatest importer and in my sample files that I exported from Turbo Lister itself, it actually contained binary digits in some fields such as shipping... You can see this yourself by exporting a file from Turbo Lister.

[batteryman]

Hello Numinix,

I loaded your latest version ebay v1.0 and I still get the wierd errors and my site is no longer viewable. I really need to get this working and figure out what is causing this to happen.

I uploaded a image of what happens to my site when i load the mysql file.

Here are the errors i get.

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


1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_DISPLAY_PRODUCTS_NEW' at line 10
in:
[SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id), zen_products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 order by pd.products_name limit -0, MAX_DISPLAY_PRODUCTS_NEW]

I hope this sheds some light on the subject. If you want I can give you more information upon request.

Thank you

Just a side note: I can load all the files okay but when I upload the sql is when everything goes haywire.

http://zen-cart.com/forum/attachment.php?attachmentid=3032&d=1196823532

This is a screenshot of what happens when I load the sql.