eBay Turbo Lister 2.0 Exporter Support Thread

Since so many of my mods support the Auction Site Attributes add-on, I have created it's own release announcement thread here:

http://www.zen-cart.com/forum/showthread.php?p=422662#post422662

Is there a way to use the Model_ID for CustomLabel instead of the product_id? The model_id will make it a lot easy to identify which product is which. Thanks!

change the line to $products->fields['products_model'];

I'll add that option to the config.

numinix:

change the line to $products->fields['products_model'];

I'll add that option to the config.

In which file do you want me to make this change? Thanks!

In the root/ebay.php. If you aren't sure, just wait as I've already added this to the next release which I will make available tomorrow or Sunday.

Is it possible to use the Large Image for the image url instead of Medium Image?

Also, how is the weight handled? Currently the mod is entering the whole weight in Weight Major. For example if a product weighs 1.5lbs, Turbo Lister expects 1 in the Weight Major and 0.5 in Weight Minor.

Is it possible to populate the upc field in Turbo Lister with the upc information that is already available? This is very useful for eBay detail information that requires upc/isbn for certain products.

Thanks for this great mod.

I didn't see a UPC field in the Turbo Lister CSV file.

Does it not work with having the entire weight in Weight Major? The next update includes the dimensions as well and converts metric. If it's having problems I will split them into major and minor.

The image handling uses the same function as Google and uses medium images. I'll change it to the Large image file for eBay and other Auction websites.

v0.95 EBAY EXPORTER

1. code optimization;

Contains some of the updates referred to recently in this thread including weight major/minor and large image files.

numinix:

I didn't see a UPC field in the Turbo Lister CSV file.

Does it not work with having the entire weight in Weight Major? The next update includes the dimensions as well and converts metric. If it's having problems I will split them into major and minor.

The image handling uses the same function as Google and uses medium images. I'll change it to the Large image file for eBay and other Auction websites.

The field that ebay uses for search for detail information for DVDs, CDs, Books, etc is UniqueIdentifier this field can contain upc, isbn or even text but that's the field I was hoping that the upc/isbn can be populated with to get eBay to include detail description.

Thanks!

It would be great if Included Categories supports category id since this will avoid confusion/conflict.

Sometimes we have categories like toys-active play and pretend and play -active play. If I just enter active play, there is no way to differentiate which active play category I want. There is possibility to have duplicate category names but each category has a unique id so that would be better if the functionality is there to support category id.

Thanks!

Is there a way to change the default value for Dimension unit to IN instead of CM and default value for Weight Units to LBS instead of KGS. I know for most people outside the U.S. the default values are fine but it sure would be nice if the default values can be changed considering there are more US eBay stores and users than any other countries. Set the default value to non-US without and option to change the default is a challenge.

Thanks!

Sorry, the output for weight units is "1". eBay fails to say what "1" stands for, but I would guess this is lbs/in. For those who have stored their values as KG/CM, it is automatically converted to LBS/IN by the eBay Exporter.

BlessIsaacola:

It would be great if Included Categories supports category id since this will avoid confusion/conflict.

Sometimes we have categories like toys-active play and pretend and play -active play. If I just enter active play, there is no way to differentiate which active play category I want. There is possibility to have duplicate category names but each category has a unique id so that would be better if the functionality is there to support category id.

Thanks!

Let me see if I have this correct. You have categories called:

Toys -> Active Play
Pretend and Play -> Active Play

In the future please differentiate sub-categories from top-level categories using a better separator.

There are bugs with this function, but it should work sufficiently enough for listing categories.

numinix:

Let me see if I have this correct. You have categories called:

Toys -> Active Play
Pretend and Play -> Active Play

In the future please differentiate sub-categories from top-level categories using a better separator.

There are bugs with this function, but it should work sufficiently enough for listing categories.

Actually the category filter is hit and miss. I have also not been able to enter a 3rd level category and have it work.

For example Clothing->shirts->men if I enter men as my category to include, it doesn't generate a feed but if enter **shirts **it generates a feed.

In the scenario you created:

Toys -> Active Play
Pretend and Play -> Active Play

How does the generator know I only want Active Play from category Toys -> Active Play but NOT Active Play from Pretend and Play -> Active Play. This is why I thought category id as a filter will be unique.

numinix:

Sorry, the output for weight units is "1". eBay fails to say what "1" stands for, but I would guess this is lbs/in. For those who have stored their values as KG/CM, it is automatically converted to LBS/IN by the eBay Exporter.

So even though the DB is showing KG/CM even when I entered LBS/IN you're saying the final output is still correct?

If you have entered LBS/IN as your units in ASA, the output in eBay will remain LBS/IN. If you are using KGS/CM, they will be converted to LBS/IN by the eBay Exporter.

The categories function should work for all levels. It takes the same input as the product_type in the Google Base Feeder and then compares each category in the array to the category name you have indicated in the eBay Exporter to include or exclude:

 
 function zen_ebay_categories($words, $compwords, $charge) {
  if ($words != '') {
   $match = 0;
   $compwords = split(",", $compwords);
   $words = split(",", $words);
   foreach ($words as $word) {
    foreach ($compwords as $compword) {
     if (trim(strtolower($compword)) == (trim(strtolower($word)))) {
      $match++;
      break;
     }
    }
   }
   if ($match > 0) {
    return true;
   } else {
    return false;
   }
  } else { // if $words is empty, return either true or false depending on positive or negative words
   if ($charge == 1) {
    return true;
   } else if ($charge == 2) {
    return false;
   }
  }
 }

numinix:

If you have entered LBS/IN as your units in ASA, the output in eBay will remain LBS/IN. If you are using KGS/CM, they will be converted to LBS/IN by the eBay Exporter.

The categories function should work for all levels. It takes the same input as the product_type in the Google Base Feeder and then compares each category in the array to the category name you have indicated in the eBay Exporter to include or exclude:

function zen_ebay_categories($words, $compwords, $charge) {
if ($words != '') {
$match = 0;
$compwords = split(",", $compwords);
$words = split(",", $words);
foreach ($words as $word) {
foreach ($compwords as $compword) {
if (trim(strtolower($compword)) == (trim(strtolower($word)))) {
$match++;
break;
}
}
}
if ($match > 0) {
return true;
} else {
return false;
}
} else { // if $words is empty, return either true or false depending on positive or negative words
if ($charge == 1) {
return true;
} else if ($charge == 2) {
return false;
}
}
}

And what happens if have duplicate category in the array if it based on category name?

When entering category is there a structure for entering category name to avoid duplicates?

For example:

Music
Kids ->music
Kids ->video

Let's say I only want to generate music from Kids-Music do I enter Kids-Music or do I enter Music? 

If you also need a temporary access I can create a user id for you but it category filter doesn't work at all levels.

BlessIsaacola:

And what happens if have duplicate category in the array if it based on category name?

When entering category is there a structure for entering category name to avoid duplicates?

For example:

Music
Kids ->music
Kids ->video

Let's say I only want to generate music from Kids-Music do I enter Kids-Music or do I enter Music?

If you also need a temporary access I can create a user id for you but it category filter doesn't work at all levels.

So four categories:

Kids -> Music
Kids -> Video

You would enter Music. However, if you have two categories called Music:

Kids -> Music
Adults -> Music

You would put Music and then in the excluded categories you would put Adults.

As I said before, this function is very basic and will take rewriting the function to use category id numbers instead. I simply took a shortcut by using the product_type to compare the categories. I'll look into this in the future but it is difficult for me to say when due to lack of time/support.

v0.96 EBAY EXPORTER

1. SQL Bug Fix;

Not an important update unless you are getting an SQL error when running the script.

If you are fimiliar with PHP/SQL, you can add this bug fix to my other scripts as well.

Change all occurences of:

GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available)

With:

 
GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0))

I loaded your program ver 0.9.6 onto my Apache server - test Zen 1.3.7 test store. Installation is simple. I get this error....

eBay Turbo Lister 2.0 Exporter v.0.9.6 29.08.2007 13:40 started 2007/09/14 22:14:17
Feed file - C:/apache2triad/htdocs/store/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]

I saw a previous post of the same error - but did not find the solution to it.
Thanks for your help