Skip to Content
0
Former Member
Apr 26, 2011 at 04:22 AM

scales for delivery charges in pricing

30 Views

Hi

Basically..

For all customers, the below logic is applied.

Below $200 = $58

$200 - $299 = $48

$300 and above = FOC

However, for certain Customers, minimum order must be $150 for FOC otherwise the charges will be $ 48, but then user can remove it manually.

for certain Customers will be determined by Industry Code 1. There can be more than 1 Industry Code 1 for academics, thus I believe we need to maintain table to capture the Industry Code 1 that can enjoy such privilege.

pls can some one guide how to mainatin in the tables and fulfill this req.

Thanks