I use easy populate to upload the catalog, easy populate does not allow you to specify 'Product priced by attributes'
can some one please correct this SQL statement for standard zc_1.3.8:
UPDATE zen_products SET products_priced_by_attribute = 1
If the products are priced by attributes and if the '+' sign prefixing the prices have to be suppressed, then the following SQL statement has to be executed :
UPDATE zen_product_attributes SET price_prefix = ''
Results 1 to 2 of 2
-
31 Jul 2009, 03:26 AM #1
Totally Zenned
- Join Date
- Feb 2007
- Posts
- 513
- Plugin Contributions
- 2
Specifying 'Product priced by attributes' by running phpmyadmin SQL query?
-
2 Aug 2009, 06:34 AM #2
Totally Zenned
- Join Date
- Feb 2007
- Posts
- 513
- Plugin Contributions
- 2
Re: Specifying 'Product priced by attributes' by running phpmyadmin SQL query?
Similar Threads
-
v139h adding attributes to all products with sql query
By delia in forum General QuestionsReplies: 8Last Post: 22 Apr 2014, 07:40 PM -
v139h Save the Multi Table Query Result in phpmyadmin or by SQL CLI
By explorer1979 in forum General QuestionsReplies: 2Last Post: 31 Dec 2013, 09:03 PM -
Need help w/ SQL query in phpMyAdmin
By audradh in forum General QuestionsReplies: 17Last Post: 16 Nov 2009, 01:05 PM -
Specifying 'Product priced by attributes' with EasyPopulate
By tryphon in forum General QuestionsReplies: 1Last Post: 5 May 2008, 08:59 PM -
How to do a "if product is priced by attributes" query?
By stehodges in forum Setting Up Categories, Products, AttributesReplies: 4Last Post: 20 Nov 2006, 06:15 PM
