Versions Compared

Old Version 5

changes.mady.by.user Danielle Chamberlain

Saved on

compared with

New Version 6

changes.mady.by.user Danielle Chamberlain

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width60%

Introduction

This document will explain how to manage multiple wine clubs across multiple brands/tasting rooms.

This pricing set-up is optional and used when you have the PS modules and are running a wine club. The customers use the same master and this give you the ability to let your customers have different pricing based on the Tasting Room and the different wine clubs someone belongs to.

Table of Contents

Table of Contents
excludeTable of Contents|Introduction|Multi Use|Use Allowed with Product Coupons|Use Allowed with Shipping Coupons|Description|Long Description|Discount Type|Effective Date Range|Customer Type|Market Code|Source Code|Region Code|Product Discounts|Shipping Discounts

 

 

Column
width40%
Panel
titleReferenced Pages
Outgoing links
Panel
titleRelated Pages
Incoming links
 
Panel
titleCentral Table References
Outgoing links
spacesSYA

 

 

 

 

 

...

Where Is It Found - System Table Set-up

PSSCM.MOC - Wine Club control- radio button #2

PS Wine Club Control

Image RemovedImage Added

Ranking Wine clubs

...

When a club member quits a club they will get the default retail Price Type (TPT), Customer Type (CTY), Market (MKT) and optionally a User Defined code (UDC) from this table.

(INSERT SCREENSHOT)

 

 

 

 When opening menu option PSSCM.MOC you are first taken to the state control, to access the Tasting room defaults you will need to click on the blue button "Tasting Room Defaults".

Image Added

When a club member has quit the wine club there is a night job that will update the customers Price type, Customer type and optionally Market and User Defined codes. The job will look to this table for the Retail codes for these customers.

Image Added

 

Info

Question: When a wine club member quit a wine club how does the system know which Tasting room entry in the MOC to use for the default retail codes?

  • When you set up Dynamic Pricing you will need to ensure that your Wine club codes (TWC) in your central table have a default tasting room assigned.
  • For example you have wine club code WC, with a default Tasting Room entry of 1. When a member quits club WC it will look to the default settings in the MOC for Tasting Room 1.

 

Central Table TWC - Entering the Default Tasting Room for each wine club code

Access may be limited to your Central Tables and you may need to talk to your In house AMS administrator for assistance.

Central tables are located under SYA - System Administration, CTL - Sub System Controls, CCT - Change central table database.

Image Added

Once in the central tables you will go to Table Code TWC. Here you will add your Default Tasting Room.

Image Added

Final step for Set Up - Going Live

*Please use caution when changing or setting up codes in your Central Table ZZZ. If you have an questions or concerns please contact the Helpdesk.*

In the central tables you will go to Table Code ZZZ.

Likely you will add this new code by typing it directly into the Code box.

Code= PSDYNCLUB

The only information here that is needed is a "Y" in the free form data. When you are done it should look like the screenshot below.

This switch turns on the ability to enter a Price Type on the customer record of "$" and the system will automatically calculate what the correct pricing would be.

Image Added

Examples

This customer belongs to two different wine clubs. The WC club gets 20% off and the 2C club gets 25% off.

Image Added

This is what the customer master would say if "$" was entered in the Price Type field and Dynamic Pricing is turned ON.

Image Added

Since the 2C club gets a higher discount and the ranking for the 2C club is higher than the WC club, it will use the pricing for the 2C club and not the WC club.

If the customer quits the 2C club, the system will automatically change the customer back to get the appropriate discount and change the customer type as needed.

The following screenshot will show you want occurred on page 2 of the customer master when she quit the 2C club.

Image Added

Image Added

  • If this customer quit all Wine Clubs they are enrolled in the "$" will stay in the customer record but it will show they are now at a Retail price.
  • It will also change their Customer Type to the default