eBid Exporter - Support Thread

[numinix]

v0.90 EBID EXPORTER

Creates a CSV file for import into eBid.

Please sign-up using the link contained in Tools->eBid Exporter

Follow the readme.txt for instructions on how to use this script, especially the NOTES section.

The CSV file cannot be imported directly into eBid, it must be resaved as a Tab Delimited file using Excel or another CSV editor.

[gxjenkins]

I'm getting the following error when trying to create the export file:

1054 Unknown column 'p.products_ebid' 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_ebid, p.products_condition, p.products_sh_na, p.products_sh_eu, p.products_sh_as, p.products_sh_au, pc.categories_id 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) LEFT JOIN products_to_categories pc ON (pc.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]

[HeathenMagic]

Hello there

I'm not getting this error, have you uploaded the SQL file at all?

[gxjenkins]

I pasted the SQL, and it ran without any errors. I also uploaded the files again, and ran the SQL again, just to make sure.
I still get the same error.
Any ideas?

[numinix]

Please install Auction Site Attributes which is required for this script. In fact, ASA was originally created for the eBid script which has many required attributes that aren't normally found in zen cart.

[gxjenkins]

I'll install ASA. I thought the readme file said that if that was not installed that configuring it under Tools, Configuration was all that was needed.
This may fix another problem I'm having with two MOD's I have installed. One of which is UPC/IBSN, and MAP Pricing.
I'll get ASA installed and let you know what happens.
Thanks.