ASA overwrites UPC/ISBN. I'll correct the SQL error in the next release for those who do not install ASA. But, like I said before, this script is useless without ASA installed.
ASA overwrites UPC/ISBN. I'll correct the SQL error in the next release for those who do not install ASA. But, like I said before, this script is useless without ASA installed.
Because I wasn't sure what would happen because I have MAP Pricing installed I installed ASA, and Ebid Exporter on another store and all went well except one statement in the SQL I had to change a parameter. The error msg said it was too large and limited to 255, so I changed it and it was O.K.
I then installed it on the the store that has MAP installed, and I didn't have to change the parameter in the SQL. That may be because the two stores are on different hosts. Anyway the ebid exporter works fine, but I don't have MAP anymore. I think I'll only have to replace "Update_Products.php" and everything should go back to normal.
I am trying to use this contribution, but i don understand how to create the product feed, please i need some help. When I go to tools>ebid exporter i get this:
eBid Exporter eBid Online Auctions USD
OVERVIEW:
This module automatically generates an eBid bulk file from your Zen Cart store.
INSTRUCTIONS:
STEP 1: Click [HERE] to create / update your product feed.
NOTE: You may view your product feed before uploading to eBid.com.
So when I click (HERE) this comes up:
eBid Exporter v.0.90 29.08.2007 18:00 started 2007/10/06 12:35:02
Feed file - /var/www/html/feed/ebid.csv
Processing: Feed - Yes, Upload - No
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]
I dont know what I have to do, I have been looking for an answer in the forum but nothing clear, please can you help.
Thanks a mill.
Noelia
i'm getting the same 1054 error. does anyone have a solution for this mod?
Upgrade to the latest version.
I no longer post my mods in the Downloads section of the Zen Cart site; for quite some time now actually...
See link in my signature.
In the latest version, make sure Auction Site Attributes is set to 'false'.