DUAL Pricing v2

[mlconti]

In order to get my bug fix working you must follow all of the steps in post #687 then add the missing SQL patch in post #695.

You will NOT be using customers_whole. If you followed the instructions in post #687 you will not have any customers_whole field in your Db either. (if you have installed the SQL patch that came with the download I can help remove it if the extra fields are producing errors)

Let me know if you need further assistance. I'm interested in your FM ODBC link...

Twitch.

ok, here is the response from that patch in 687

Failed: 4
ERROR: Cannot ADD column products_price_w because it already exists.
ERROR: Cannot ADD column options_values_price_w because it already exists.
ERROR: Cannot ADD column discount_price_w because it already exists.
ERROR: Cannot ADD column customers_wholesale because it already exists.
Note: 4 statements ignored. See "upgrade_exceptions" table for additional details.

I tried to install this way back before the bugs were known, but did not put much effort into making it work until yesterday. So if you think the original install created some unknown issue, let me know.

I can prob delete the customers_whole via phpmyadmin, however it is the only thing allowing it to work so I'd rather find the bug and then remove the unnecessary data.

I will work on this some more and keep you posted. let me know about your fix.

I will be glad to share my knowledge to make the bridge into zen cart from FM.

Thanks.

M

[mlconti]

I also got this message while working in the admin section of zen cart

1054 Unknown column 'p.product_price_w' in 'field list'
in:
[select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.product_price_w, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order from products p, products_description pd where p.products_id = pd.products_id and p.products_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


any advise?

Thanks,

M

[twitchtoo]

ok, here is the response from that patch in 687

Failed: 4
ERROR: Cannot ADD column products_price_w because it already exists.
ERROR: Cannot ADD column options_values_price_w because it already exists.
ERROR: Cannot ADD column discount_price_w because it already exists.
ERROR: Cannot ADD column customers_wholesale because it already exists.
Note: 4 statements ignored. See "upgrade_exceptions" table for additional details.

I tried to install this way back before the bugs were known, but did not put much effort into making it work until yesterday. So if you think the original install created some unknown issue, let me know.

I can prob delete the customers_whole via phpmyadmin, however it is the only thing allowing it to work so I'd rather find the bug and then remove the unnecessary data.

I will work on this some more and keep you posted. let me know about your fix.

I will be glad to share my knowledge to make the bridge into zen cart from FM.

Thanks.

M

If you followed the instructions in my bug fix customers_whole no longer exists.

What version of the dual pricing module do you have and what version of ZenCart?

I have the SQL patch to remove the customers_whole field properly, I used it in my original install successfully.

The error above is ok it means the other fields already exist.

Twitch.

[mlconti]

Zen Cart is v1.3.9h and well I think the latest dual price is 1.7c?

I also had tried installing the hide dual price or something like that. - not sure that even worked or was installed.

What are your thoughts?

[twitchtoo]

Zen Cart is v1.3.9h and well I think the latest dual price is 1.7c?

I also had tried installing the hide dual price or something like that. - not sure that even worked or was installed.

What are your thoughts?

Personally I would start over with the default template files, install the dual pricing module, walk through the bug fix that I made, make sure it works... then attempt to install another module.

If you install anything that wants to overwrite ANY of the files used in the dual pricing module you will have to compare them and manually add in the code. Be sure to backup any files that are working correctly prior to the changes!

Twitch.

[missta]

Hey Twitch,
First of all i would like to thank you for the great guide. For a new new zenner like me, i was able to understand it easily.

I followed all the steps. No more errors like before.

One problem: After changing the customer to level 1, they don't see 2 prices (retail & wholesale) when i logged in as a customer. All i see is the wholesale price.

I did this, but do not see 2 prices.
"Step 17 - Click on Catalog, Select a Product, Add in a Wholesale Price (right below the 'Products Price (Gross)')

Step 18 - Log into your live ZenCart test account - like a customer would, you will see 'Whole Sale Price:' below the retail price of the product you added a wholesale price to in Step 17." Quote from http://www.zen-cart.com/forum/showth...=35450&page=69

Step 19 - Thank me. Thank you very much.

You can see with is screenshop:http://greenletdesigns.com/no2prices.jpg

Did i forget to do something?

[twitchtoo]

Hey Twitch,
First of all i would like to thank you for the great guide. For a new new zenner like me, i was able to understand it easily.

I followed all the steps. No more errors like before.

One problem: After changing the customer to level 1, they don't see 2 prices (retail & wholesale) when i logged in as a customer. All i see is the wholesale price.

I did this, but do not see 2 prices.
"Step 17 - Click on Catalog, Select a Product, Add in a Wholesale Price (right below the 'Products Price (Gross)')

Step 18 - Log into your live ZenCart test account - like a customer would, you will see 'Whole Sale Price:' below the retail price of the product you added a wholesale price to in Step 17." Quote from http://www.zen-cart.com/forum/showth...=35450&page=69

Step 19 - Thank me. Thank you very much.

You can see with is screenshop:http://greenletdesigns.com/no2prices.jpg

Did i forget to do something?

This issue has two parts. The part I fixed looks to be the part you are trying to see, that is that when you edit a product you should see this:

Tax Class: --none-- GST on Kids Clothing GST on Shipping GST/HST/PST Class Taxable Goods Products Price (Net): Products Price (Gross): Wholesale Price (Net)
If there is no wholesale price, set this field to 0

Once you have a price entered it will work correctly when you log in as a wholesale customer, or as a retail customer. NOTE that you must log out and log back in if you are toggling the wholesale feature on and off in admin. The session only records the customers_wholesale value on the login page.

The second part I am working on a bug fix right now, that is pricing with attributes, multiple sizes, colours and multiple prices by size for retail and wholesale. I have not completed the fix for this bug yet. When I do, I will post it here... and take a day off!

Twitch.

[twitchtoo]

Here is the image you should see:

I missed the window of time to get it in the post above...

Twitch.

[missta]

Twitch,

This is what I see in the admin page:


****************
But when I sign in as a customer-with level one: I only see 1 price.
I cleared & closed the browser, cleared all browsing history from last day. Tried with internet explorer too. and this is what i see.

[twitchtoo]

Check that this file:
includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php

contains this code:

// base price
//***********************************************************************
//***DISPLAY NET RETAIL PRICE IF WHOLESALE CUSTOMER IS LOGGED ON
//***********************************************************************
if ($_SESSION['customers_wholesale'] && $_SESSION['customers_wholesale'] != '0' ) {
echo '<span id="retailwhole">' . ' Retail Price: '.$one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == '1') ? TEXT_BASE_PRICE : '') . zen_get_products_display_retail_net_price((int)$_GET['products_id']).'</span><br /> ';
}
//***********************************************************************
//***END DISPLAY NET RETAIL PRICE IF WHOLESALE CUSTOMER IS LOGGED ON
//***********************************************************************

if ($show_onetime_charges_description == 'true') {
$one_time = ' <span> Your Price: ' . TEXT_ONETIME_CHARGE_SYMBOL . TEXT_ONETIME_CHARGE_DESCRIPTION . '</span><br />';
} else {
$one_time = '';
}
//******************************************************************************** *
//***Properly display price labeling when set to Whole sale and when not
//******************************************************************************** *
if ($_SESSION['customers_wholesale'] && $_SESSION['customers_wholesale'] != '0' ) {
echo '<span id="whole">Whole Sale Price: ';
} else {
echo '<span id="retail">Retail Price: ';
}
echo $one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == 1) ? TEXT_BASE_PRICE : '') . zen_get_products_display_price((int)$_GET['products_id']);
echo '</span>';
//******************************************************************************** *
//***END Properly display price labeling when set to Whole sale and when not
//******************************************************************************** *

Those echo lines actually print the code on the screen in the cart. Meaning two things, if they don't exist there will be nothing to print and, if they do exist, there is a break somewhere in the equation that is passing the information to them to print.

Just to check, you have added this SQL patch from post #695:
ALTER TABLE `customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL;

Twitch.