[FONT=Comic Sans MS]Vicki[/FONT]
www.moebiusenterprises.com
Fragrance*jewelry*metaphysical supplies*art*LIFE ... 'bout sums it up....
You should always install SQL patches using the INSTALL SQL PATCHES from within the Zen Cart admin. It will automatically apply the table prefixes.
v1.0.2 AUCTION SITE ATTRIBUTES
1. bug fixThis update fixes the missing product_weight attribute. Only file that you need to replace is collect_info.php. No other files were edited in this update.
v0.9.4 EBAY EXPORTER
1. Bug fix in /ebay.phpThose are the only files you need to upload. What this update does is if there is no image, it will turn gallery off for that product regardless of whether you have set it as on in the configuration.
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?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.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]
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.
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...