DUAL Pricing v2

[adalton]

Chrome Orange,

I was just hired to take over this site and finish for a client. Last developer skipped town. Never used Zen cart before so excuse me if some questions are obvious. Tried to read up a lot on this forum first, but might have missed some answers.

1. Client has version 1.2.6 - do I need to upgrade to newest version to use your mod?

2. Client does wholesale and retail. Does this mod allow secure login for wholesalers to see wholesale prices?

3. Client has $250.00 min. for first time wholesale orders. A $150.00 reorder min. For the $150.00 reorder min. they have a $10.00 service fee if the min. is not met. Does your mod support such rules?

That's all I can think of now, but sure I will have more later!
Thanks for your help.

[craftzombie]

Chrome Orange,

I was just hired to take over this site and finish for a client. Last developer skipped town. Never used Zen cart before so excuse me if some questions are obvious. Tried to read up a lot on this forum first, but might have missed some answers.

1. Client has version 1.2.6 - do I need to upgrade to newest version to use your mod?

2. Client does wholesale and retail. Does this mod allow secure login for wholesalers to see wholesale prices?

3. Client has $250.00 min. for first time wholesale orders. A $150.00 reorder min. For the $150.00 reorder min. they have a $10.00 service fee if the min. is not met. Does your mod support such rules?

That's all I can think of now, but sure I will have more later!
Thanks for your help.

Hey there, I'm not sure if Chrome Orange still posts here, so excuse me for butting in....

1. Do your client a favor and upgrade to the newest version of Zen Cart and use the newest version of this mod.

2. Yes, there is a secure login and they will see wholesale prices (after you have made the necessary switch in their customer details).

3. This mod doesn't support those kinds of rules, although I believe there are other mods out there for minimum orders and service fees. Those would also affect your retail customers though, so you'd have to tweak the code in those mods to recognize when a wholesale customer is logged in. How I get around it is... I have a wholesale info page where I state the minimums and other info. I explain how the cart will allow checkout for less than the minimum and that any wholesale order not meeting my minimum requirements may be subject to cancellation. I have also added "minimum wholesale order $150" to the shopping cart and checkout pages with a link to the wholesale info page. This has worked well for me, but may not for your client, I don't know.

[waltinrio]

OK...hope im not messed up here... I dl'd the mod and made sure (twice) that all files were in place. I ran admin and when it comes up it gives me this...

1054 Unknown column 'p.products_price_w' in 'field list'
in:
[select p.products_type, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_price_w, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_model, 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_quantity_order_max, p.products_sort_order from zen_products p, zen_products_description pd, zen_products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '36' order by p.products_sort_order, pd.products_name limit 0, 500]
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.

This is in between the dropdowns and the catagory fields. It says to run an sql patch that is provided. How do I do this? I know...Im new...please help...thanx

[adalton]

Thank you craft zombie. I was thinking the same about the minimums. Just state it on the site in appropriate places and such. Good suggestions.

[madfastride]

This is in between the dropdowns and the catagory fields. It says to run an sql patch that is provided. How do I do this? I know...Im new...please help...thanx

Admin>tools>install SQL patches

copy and paste the three lines, from the Read Me, that being with "ALTER TABLE" Then execute on your DB...

As always, it's a good idea to back up your DB before performing any DB maintenance or upgrades...

[madfastride]

1. I only sell CD's and set the product type as Music, but when editing a product there is no where to enter the wholesale prices (although it is working in the General product type). Will this work with Music product types or will I have to set my products to General?
Many thanks

I've uploaded a modified version (1.4.1) with functionality for Music products... It's the only change that was made.

Thanks,

[vambo]

I've uploaded a modified version (1.4.1) with functionality for Music products... It's the only change that was made.

Thanks,

Madfastride, thanks that is really great of you.

Where can I download v1.4.1 from?

[madfastride]

Madfastride, thanks that is really great of you.

Where can I download v1.4.1 from?

The download area...

http://www.zen-cart.com/index.php?ma...roducts_id=166

[vambo]

Thanks, I found it last night.

I got 2 errors in product_music/collect_info.php at lines 22 and 380 where you had left in your virtual paths, and I also got the same error in product_music/update_product.php on line 37 but, after deleting the paths, it all seems to be working.

Thanks very much for your work, I really appreciate it.

[madfastride]

I got 2 errors in product_music/collect_info.php at lines 22 and 380 where you had left in your virtual paths, and I also got the same error in product_music/update_product.php on line 37 but, after deleting the paths, it all seems to be working.

Yeah sorry about that I did this a little rushed... I just submitted 1.4.2 that fixed these errors. It might take a night for it to actually post...

Thanks very much for your work, I really appreciate it.

Your welcome...