eBay Turbo Lister 2.0 Exporter Support Thread

thanks maxrisc, I'll take a look.

I've just released the auction site attributes add-on module to support the eBay Turbo Lister 2.0 Exporter contribution. I will announce it's release here rather than create a new thread:

**v1.0.0**** AUCTION SITE ATTRIBUTES**

1. adds additional attributes for ebid, ebay, amazon, and epier;- including:- flat rate shipping costs per product per continent;

• site category id's;Once the eBay, ePier, Amazon, and eBid feeders have been updated to support this release, you will be able to save a great deal of time by setting the category id's of each website as well as flat rate shipping per continent only once.

So why release this module before the mods it supports?

This will give store owners time to update these attributes in each of their products (I'll be updating Quick Updates next to include these attributes).

Future releases of this add-on are very possible due to other similar attributes that exist between each of the sites.

I'm working on the next public release of the eBay exporter and have included a new feature. For those of you who have eBay stores, in the auction site attributes module when inputting the eBay category you can also put your store category like this:

eBay Category ID: 5555,1

The 5555 will be used in the eBay exporter as the global category and 1 as the store category.

There are a couple of bugs in ASA 1.0.0, I'll update it right away.

numinix:

There are a couple of bugs in ASA 1.0.0, I'll update it right away.

You may also wish to make certain it supports the possibility of file prefixes in the DB.

Moebiusenterprises:

You may also wish to make certain it supports the possibility of file prefixes in the DB.

LOL... don't worry this script was designed specifically for zen-cart.

**v1.0.1**** AUCTION SITE ATTRIBUTES**

1. Added excluded products by title keywords;
2. Added Auction Site Attributes module support;

v0.9.3 EBAY EXPORTER (notice name change)

1. supports auction site attributes module (MANDATORY even if not used);
2. added excluded products by title keywords filter;This update only supports the ebay category numbers and not the flat rate shipping rates as unfortunately they aren't imported in text format by Turbo Lister. These attributes will be used mostly for the upcoming eBid contribution.

To use the eBay categories with Auction Site Attributes, input the ebay category and then the store category separated by a comma, no spaces. Example: 5555,1 will set ebay_cat = 5555 and store_cat = 1.

Note: name change is to avoid confusion that this module also supports selling manager pro as well as turbo lister and to shorten the name. The name change hasn't been updated in the SQL and therefore isn't official, yet...

The next release will support product dimensions for calculated shipping rates.

I need to know the following, other than the Canada Post module, which shipping modules have added product dimensional support. This would mean that your products.php page will display input fields for dimensions. Once I have a list of contributions that already have dimensional support, I'll see if they use the same column names in the database. If not, I may have to create a brand new section to the ASA mod where you can input package dimensions as well.

eBay supports calculated shipping rates through UPS, USPS and possibly other shipping companies, but they require dimensions in order to return a value.

Another note for the ASA mod:

To find the eBay categories, go to eBay (whichever domain you use) and browse categories. Click show category numbers.

numinix:

LOL... don't worry this script was designed specifically for zen-cart.

:laugh:
So are a lot of others... and they still forget about things like Fantastico :smile:

Will upgrade & let you know....

You should always install SQL patches using the INSTALL SQL PATCHES from within the Zen Cart admin. It will automatically apply the table prefixes.

numinix:

LOL... don't worry this script was designed specifically for zen-cart.

Moebiusenterprises:

You may also wish to make certain it supports the possibility of file prefixes in the DB.

Nice dig.

**v1.0.2**** AUCTION SITE ATTRIBUTES**

1. bug fix

v0.9.4 EBAY EXPORTER

1. Bug fix in /ebay.php
2. Mod title changed in admin/languages/.

Numinix,

Thanks for this great mod. I am assuming that I am getting the following error because I have not installed auction site attribute? > eBay Turbo Lister 2.0 Exporter v.0.9.3 14.08.2007 13:11 started 2007/08/23 17:49:42

Feed file - /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, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, s.specials_new_products_price, s.expires_date, p.products_ebay FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_id) LEFT JOIN 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]

Did your auction site attribute take into account the standard out of the box product type included with Zen Cart? I asked this because I know with your upc/isbn mod the only product_type that presents the input field for upc/isbn is the general product type which negates the use of standard product_type like music.

Obviously, the functionality is useless if there is no field on the screen to enter the data to the database so the feed can be generated with the information that is needed.

Assuming you're not going to support product type, is there an easy to roll back all your mod that offer great functionality that we cannot use because there is not screen access to the functionality. This problem currently exists in Google Base feed and MSN Product Feed.

Also, is there any modification needed to use Quick Update for mass changing the fields?

Thanks for all your great work!

Numinix,

I hope you did not take my last post the wrong way. I am basically trying to appeal to you to guide us in the right direction to make the additional fields available for other product types.

Thanks!

No I didn't, don't worry. I understand how it can be frustrating that the additional attributes do not support other product types. I actually don't know how the product_types work and didn't know they have a different page for collecting info. I'll take a look into it later. But if you look at ASA and the UPC/ISBN (ASA now replaces UPC in my next release coming soon...), you will see how to add fields. Perhaps you can let me know which files are used for music product types and I'll look into adding it in the next release.

That version of eBay Exporter requires the ASA attributes and there is not previous version that I can currently support. I'll take into consideration your requests and you can expect them in the next release.

I'm current;y beta testing my Amazon Exporter and I have ASA attributes ready to be released.

numinix:

No I didn't, don't worry. I understand how it can be frustrating that the additional attributes do not support other product types. I actually don't know how the product_types work and didn't know they have a different page for collecting info. I'll take a look into it later. But if you look at ASA and the UPC/ISBN (ASA now replaces UPC in my next release coming soon...), you will see how to add fields. Perhaps you can let me know which files are used for music product types and I'll look into adding it in the next release.

That version of eBay Exporter requires the ASA attributes and there is not previous version that I can currently support. I'll take into consideration your requests and you can expect them in the next release.

I'm current;y beta testing my Amazon Exporter and I have ASA attributes ready to be released.

Thanks for your response. It's actually not that any field is missing for any of the product types. The problem is that for example upc/isbn field are not available for data entry when using product type music.

If you look at the url when updating general product the file that Zen Cart is using is product.php and when updating music you will notice it is using product_music.php and so forth.

When you released the upc/isbn or asa mod you released an update to admin/includes/languages/english/product.php that updated code is what's making the new fields like upc/isbn available when adding/editing a general product.

However, you did not include the updated code in other product types like admin/includes/languages/english/product.php/product_music.php which I suspect is why the fields are not showing.

Make sense?

Yes, I looked it up last night and found that Zen-Cart requires updating of two additional pages per product type which basically means cloning the entire script for each type. I'm going to have it completed today and released on my website. Staye tuned...