eBay Turbo Lister 2.0 Exporter Support Thread

[BlessIsaacola]

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!

[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.

[numinix]

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.

[BlessIsaacola]

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.

[BlessIsaacola]

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?

[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;
   }
  }
 } 

[BlessIsaacola]

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.

[numinix]

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.

[numinix]

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

[2004g35]

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