DUAL Pricing v2

embepo:

I tried it but its all the same... Thanks man for ur help but I guess this is really complicated and writing a script for this problem is a really big goal. I dont know why but english version runs quite well but slovak version show only prices and no description and head titles... Please if you know why its not working, tell me how can I transport database from oscommerce shop to zencart shop.

Thanks
embepo

embepo... sorry but I think you meant to post this on "****OsCommerce Data Importer - Errors**" **

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.

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.

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.
   :smile:

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

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.

waltinrio:

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...

vambo:

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,

madfastride:

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. :cool:

Where can I download v1.4.1 from?

vambo:

Madfastride, thanks that is really great of you. :cool:

Where can I download v1.4.1 from?

The download area...

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=166

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. :bigups:

vambo:

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...

vambo:

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

Your welcome...

I seem to be having 2 more issues with ther wholesale version of the mod.

1. Regardless of what set the store to in the "My Store" section, it remains in Showcase mode and nothing can be ordered.

2. In category and products screen, my "red dots" and the legend is duplicated, I have 2 sets of them showing in admin.

thank you,

betty

bettysue:

1. Regardless of what set the store to in the "My Store" section, it remains in Showcase mode and nothing can be ordered.
   I don't know how Dual Pricing could be effecting this. Sorry Betty I think your problem might lie outside of this mod or I don't quite understand the issue.

bettysue:

2. In category and products screen, my "red dots" and the legend is duplicated, I have 2 sets of them showing in admin.
   I see this. I fixed it for a future version but it seems a little bit to small of a problem to post a new version for as it is cosmetic, and it's in the Admin side of things.

In the mean time if you'd like to remove it, delete lines 21-30 in admin/includes/modules/category_product_listing.php

Cheers,

You were absolutely correct on item 1, it was a setting in the customers settings. My apologies for thinking it had to do with the mod.

Thank you for the fix for the other issue. My client was just asking about it that's all.

betty

I am having difficulty with wholesale price not showing on order. It shows the qty., product name, correct delivery rate, priority handling, calculates GST & PST on those two items (shows in Total) BUT the Sub-Total is $0.00.
I have a minimum order which takes into calculation and would not let me check-out with a lesser amount, (so I know the amount is there somewhere);
When I add items, it shows Unit $0.00 Total $0.00 BUT Sub-Total shows correct amount. When I click on checkout, the Sub-Total is $0.00.

Where should I look??
Thanks
Veronika

Veronika7747:

I am having difficulty with wholesale price not showing on order. It shows the qty., product name, correct delivery rate, priority handling, calculates GST & PST on those two items (shows in Total) BUT the Sub-Total is $0.00.
I have a minimum order which takes into calculation and would not let me check-out with a lesser amount, (so I know the amount is there somewhere);
When I add items, it shows Unit $0.00 Total $0.00 BUT Sub-Total shows correct amount. When I click on checkout, the Sub-Total is $0.00.

Where should I look??
Thanks
Veronika
i found it.. one line in shopping_cart.php ...

Hi there,

We've had the dual pricing module installed on a client site for a while and it's been working fine. Now the client wants to be able to set minimum quantities for products (which they didn't earlier), but crucially, they only want these minimums to apply to wholesale clients, retailers should be able to buy any amount. The quantities vary between products.

I've done a lot of searching in the forums and with Google, but can't seem to find any relevant information, so would be really grateful if someone has any thoughts on this!

Thanks, karl

karl19:

We've had the dual pricing module installed on a client site for a while and it's been working fine. Now the client wants to be able to set minimum quantities for products (which they didn't earlier), but crucially, they only want these minimums to apply to wholesale clients, retailers should be able to buy any amount. The quantities vary between products.

I've done a lot of searching in the forums and with Google, but can't seem to find any relevant information, so would be really grateful if someone has any thoughts on this!
Karl,
With out looking at how complicated this would be there is always possibility to change any functionality in ZC to only apply to WS customers. Please look back at some previous posts where I have mentioned the bit of code to use...
In your case just take the Minimum quantity function all ready built in and wrap the code around it on the front end so that it only applies to WS customers. I've done some great little customizations to ZC for dual pricing this way already.

Madfastride,
Thanks for the reply! Yep, in the end we figured out where the minimum quantity function was called and did a check for whether the customer logged in was a wholasaler or not. Things seem to be working fine now. We've also managaed to do a number of little checks and variations in content based on this WS-switch - good fun.

hi madfastride,
i upgrade from 1.3.2 to 1.4.2 to your script.

when i do diff to compare your dual pricing mod.

i wonder why you don't use the most update 1.3.8a to modify the code rather than using your current one?

as i know that the new 1..3.8a in some files, such as function_price and class/shopping_cart.php has do some bugs fix.

looking for your updated file to download.