INTERNAL - Bepoz Help Guides

End-User | Pricing, Marketing, Promotions & Accounts

Product Promotions

8 | Generic Product Promotion Import Scheduled Job (Auto)

This article outlines a brief overview of Importing a Product Promotion from a Bepoz Generic file format; this i ncludes how to create a Scheduled Job under JobExport.dll called "Generic Product Promo Import". The Scheduled Job will i mport Flat file/excel from a Windows file directory and it s upports both Price Promotions and Multibuys.

This article outlines a brief overview of Importing a Product Promotion from a Bepoz Generic file format; this includes how to create a Scheduled Job under JobExport.dll called "Generic Product Promo Import".

The Scheduled Job will import Flat file/excel from a Windows file directory and it supports both Price Promotions and Multibuys.

Prerequisites

Job Settings

This Scheduled Job will retrieve Product information and import it directly into BackOffice
To add this Scheduled Job in BackOffice, log into BackOffice, and complete the following steps:

Navigate to System Setup and select Scheduled Jobs
Select Add Job button and the Job Maintenance window will open
There are a number of credentials that need to input and they include:

Job Name: Give the Job a relevant name
Job Type: External DLL
DLL Name: Jobexport.DLL
ClassName: Generic Promotions Import

Job Option will also require a number of configuration as well:

Import Inactive: By default, it is set to false; if this flag is true, the import is inactive
File Location: This is the location of the file to be imported; after import, the file is archived
Archive Location: This is the location of archived files after import
Default Priority: This will set the Product Promotions' priority based on the value; the value ranges to 1-20
Default Discount Totaliser: This will set the Discount Totaliser for the promotion based on the value; the value ranges to 1-30
Default Venue/s: Select the VenueID to match in the file to determine the VenueID; else use this setting if this is not specified in the import file
Default Store/s: Select the Stores or Storegroups; else use this setting if this is not specified in the import file
Default Till/s: Select the WorkstationID to match to the Product Promo Till ID; use this setting if this is not specified in the import file
Default Account Profile: Select the value to the AccProfileID to match; use this setting if this is not specified in the import file

Select Run Now! to run the Job immediately (as opposed to running based on the Schedule) and click OK to save the Scheduled Job

Field Definitions Header

Create a spreadsheet using flat-file/Excel to set up a promotion
Save the Promotion files in a .CSV format
You will be creating a Header Definition and Line Definition so it would map the File Fields from BackOffice
Input the File Field using the Index on the below Header Definition
Using the Bepoz Notes, input the record entry per line

==============TABLE====================

Index	File Field	Bepoz Field	Bepoz Notes
A	Record Type	-	This will indicate what type of record entry this is H = Header Lines with no valid record type will be ignored
AA	Third ProductID	ProdPromo.ThirdProdID	Mix n Match Only This is the ProductID/ProductGroupID that determines the products for the third set of products in Mix N Match
AB	Third Product Size	ProdPromo.ThirdProdSize	Mix n Match Only This is the Product Size that will be made available in the promotion for the third set of products. 0 = All Sizes 1 = Size 1 2 = Size 2 3 = Size 3 4 = Size 4 5 = Size 5 6 = Size 6 7 = Size 7 8 = Size 8 9 = Size 9 10 = Size 10
B	ProdPromoNum		Used just for the file to match header and line records. Any line records with the same ProdPromoNum will attach to the header promotion
C	Name	ProdPromo.Name	Use this to determine a single product promotion. If there are multiple Header records with different names, there should be more than one promotion that is imported This should be used to make up the name of the promotion
D	PromotionType	ProdPromo.PromotionType	Price Promotion or Multibuy 0 = Price Promotion 1 = Multibuy
E	Description	ProdPromo.Description	This will map to the Product Promotion description
F	Start Date	ProductPromo Schedule Start Date	This will be the start date in the schedule for the promotion. A schedule will be created based on the start and end date specified.
G	End Date	ProductPromo Schedule End Date	This will be the end date in the schedule for the promotion. A schedule will be created based on the start and end date specified.
H	Priority	ProductPromo.Priority	Value is 1-20. This will set the Product Promotions priority based on the value. If not specified, will default to job settings
I	Discount Totaliser	ProductPromo.DiscountNum	Value is 1-30. This will set the Discount Totaliser for the promotion If not specified, will default to job settings
J	Venue	ProductPromo.VenueID	Match off VenueID in the file to determine VenueID. Need to have Venues, Venue Sets and Venue groups supported in the mapping. The values as represented in the database should be supported here. For example, -2 references a venuegroup and -101 would represent the Venue Set. If not specified, will default to job settings
K	Store	ProductPromo.StoreID	Match off VenueID in the file to determine VenueID. Need to have Stores and Store groups supported in the mapping. The values as represented in the database should be supported here. For example, -2 references a storegroup. If not specified, will default to job settings.
L	Till	ProductPromo.TillID	Match the WorkstationID to the Product Promo Till ID. If not specified, will default to job settings
M	Account Profile	ProductPromo.AccProfileID	Match the value to the AccProfileID. If not specified, will default to job settings
N	Inactive	ProductPromo.InActive	True or False. If True, import the promotion with the inactive flag on If False, import the promotion with the inactive flag off If no value set, set the value to false
O	Pricingtype	ProdPromo.Pricingtype	Multibuy Only Below are the values to match on. These are string values:
P	Qty Required	ProdPromo.QtyReq	Multibuy Only This is the qty required to trigger the products in the multibuy. For example, 2 coronas for $5 would need 2 set as the Qty Required. Values are set in hundredths
Q	Price	ProdPromo.Price	Multibuy Only This is the multibuy price/discount For example, if value is 5000 and Disc Percent was the Pricing Type, this would indicate 50% off items that qualify for the multibuy. Values are set in hundredths
R	MBPriceMode	ProdPromo.MBPriceMode	Mix n Match Only This determines how the price is calculated. The below options need to be supported in the file as string values:
S	Second Qty Required	ProdPromo.SecondQtyReqd	Mix n Match Only This is the qty required to trigger the 2nd set of products in the Mix N Match.
T	Second Price	ProdPromo.SecondProdPrice	Mix n Match Only This is the multibuy price/discount dependent on the SecondMBPriceMode for the second set of products for the Mix N Match. For example, if value is 5000 and Disc Percent was the MB Price Mode, this would indicate 50% off items that qualify for the multibuy. Values are set in hundredths
U	SecondMBPriceMode	ProdPromo.SecondMBPriceMode	Mix n Match Only This determines how the price is calculated for the second set of products in Mix n Match. The below options need to be supported in the file as string values:
V	Second ProductID	ProdPromo.SecondProdID	Mix n Match Only This is the ProductID/ProductGroupID that determines the products for the second set of products in Mix N Match
W	Second Product Size	ProdPromo.SecondProdSize	Mix n Match Only This is the Product Size that will be made available in the promotion for the second set of products. 0 = All Sizes 1 = Size 1 2 = Size 2 3 = Size 3 4 = Size 4 5 = Size 5 6 = Size 6 7 = Size 7 8 = Size 8 9 = Size 9 10 = Size 10
X	Third Qty Required	ProdPromo.ThirdQtyReqd	Mix n Match Only This is the qty required to trigger the 3rd set of products in the Mix N Match.
Y	Third Price	ProdPromo.ThirdProdPrice	Mix n Match Only This is the multibuy price/discount dependent on the ThirdMBPriceMode for the third set of products in Mix N Match. For example, if value is 5000 and Disc Percent was the MB Price Mode, this would indicate 50% off items that qualify for the multibuy. Values are set in hundredths
Z	ThirdMBPriceMode	ProdPromo.ThirdMBPriceMode	Mix n Match Only This determines how the price is calculated for the third set of products in Mix n Match. The below options need to be supported in the file as string values:

==============TABLE====================

Field Definitions Line

Input the File Field using the Index on the below Line Definition.
Using the Bepoz Notes, input the record entry per line.

==============TABLE====================

Index	File Field	Bepoz Field	Bepoz Notes
A	Record Type		This will indicate what type of record entry this is L = Line Lines with no valid record type will be ignored
B	ProdPromoNum		Match based off header record Used just for the file to match header and line records to create a promotion in Bepoz
C	ProductID	PPProd.ProductID	This is the ProductID/ProductGroupID that determines the products that will be available for the promotion
D	Product Size	PPProd.Size	This is the Product Size that will be made available in the promotion for the product/s. 0 = All Sizes 1 = Size 1 2 = Size 2 3 = Size 3 4 = Size 4 5 = Size 5 6 = Size 6 7 = Size 7 8 = Size 8 9 = Size 9 10 = Size 10
E	Description	-	Used to make file human readable and to work with.
F	Price	PPProd.Price	If field has value, set the value in the price field and also flag PPProd.UsePrice as true. Values are set in hundredths
G	Discount Amount	PPProd.DiscAmt	If field has value, set the value in the DiscAmt field and also flag PPProd.UseDiscAmt as true. Values are set in hundredths
H	Discount Percent	PPProd.DiscPerc	If field has value, set the value in the DiscPerc field and also flag PPProd.UseDiscPerc as true. Values are set in hundredths
I	Points Earn	PPProd.PointsEarn	If field has value, set the value in the PointsEarn field and also flag PPProd.UsePointsEarn as true. Values are set in hundredths
J	Points Redeem	PPProd.PointsRdm	If field has value, set the value in the PointsRdm field and also flag PPProd.UsePointsRdm as true. Values are set in hundredths A -1 will set the Redeem Not Allowed flag.

==============TABLE====================

Sample

If an error occurs with the import, this should be written into an error file with the error detail in the same directory as specified for import

8 | Generic Product Promotion Import Scheduled Job (Auto)

Index

File Field

Bepoz Field

Bepoz Notes

A

Record Type

-

This will indicate what type of record entry this isH = HeaderLines with no valid record type will be ignored

AA

Third ProductID

ProdPromo.ThirdProdID

Mix n Match OnlyThis is the ProductID/ProductGroupID that determines the products for the third set of products in Mix N Match

AB

Third Product Size

ProdPromo.ThirdProdSize

Mix n Match OnlyThis is the Product Size that will be made available in the promotion for the third set of products.0 = All Sizes1 = Size 12 = Size 23 = Size 34 = Size 45 = Size 56 = Size 67 = Size 78 = Size 89 = Size 910 = Size 10

B

ProdPromoNum

Used just for the file to match header and line records. Any line records with the same ProdPromoNum will attach to the header promotion

C

Name

ProdPromo.Name

Use this to determine a single product promotion. If there are multiple Header records with different names, there should be more than one promotion that is importedThis should be used to make up the name of the promotion

D

PromotionType

ProdPromo.PromotionType

Price Promotion or Multibuy0 = Price Promotion1 = Multibuy

E

Description

ProdPromo.Description

This will map to the Product Promotion description

F

Start Date

ProductPromo Schedule Start Date

This will be the start date in the schedule for the promotion. A schedule will be created based on the start and end date specified.

G

End Date

ProductPromo Schedule End Date

This will be the end date in the schedule for the promotion. A schedule will be created based on the start and end date specified.

H

Priority

ProductPromo.Priority

Value is 1-20. This will set the Product Promotions priority based on the value.If not specified, will default to job settings

I

Discount Totaliser

ProductPromo.DiscountNum

Value is 1-30. This will set the Discount Totaliser for the promotionIf not specified, will default to job settings

J

Venue

ProductPromo.VenueID

Match off VenueID in the file to determine VenueID. Need to have Venues, Venue Sets and Venue groups supported in the mapping.

The values as represented in the database should be supported here. For example, -2 references a venuegroup and -101 would represent the Venue Set.If not specified, will default to job settings

K

Store

ProductPromo.StoreID

Match off VenueID in the file to determine VenueID. Need to have Stores and Store groups supported in the mapping.The values as represented in the database should be supported here. For example, -2 references a storegroup.If not specified, will default to job settings.

L

Till

ProductPromo.TillID

Match the WorkstationID to the Product Promo Till ID. If not specified, will default to job settings

M

Account Profile

ProductPromo.AccProfileID

Match the value to the AccProfileID. If not specified, will default to job settings

N

Inactive

ProductPromo.InActive

True or False.If True, import the promotion with the inactive flag onIf False, import the promotion with the inactive flag offIf no value set, set the value to false

O

Pricingtype

ProdPromo.Pricingtype

Multibuy OnlyBelow are the values to match on. These are string values:

P

Qty Required

ProdPromo.QtyReq

Multibuy OnlyThis is the qty required to trigger the products in the multibuy. For example, 2 coronas for $5 would need 2 set as the Qty Required. Values are set in hundredths

Q

Price

ProdPromo.Price

This will indicate what type of record entry this is
H = Header
Lines with no valid record type will be ignored

Mix n Match Only
This is the ProductID/ProductGroupID that determines the products for the third set of products in Mix N Match

Mix n Match Only
This is the Product Size that will be made available in the promotion for the third set of products.
0 = All Sizes
1 = Size 1
2 = Size 2
3 = Size 3
4 = Size 4
5 = Size 5
6 = Size 6
7 = Size 7
8 = Size 8
9 = Size 9
10 = Size 10

Use this to determine a single product promotion. If there are multiple Header records with different names, there should be more than one promotion that is imported
This should be used to make up the name of the promotion

Price Promotion or Multibuy
0 = Price Promotion
1 = Multibuy

Value is 1-20. This will set the Product Promotions priority based on the value.
If not specified, will default to job settings

Value is 1-30. This will set the Discount Totaliser for the promotion
If not specified, will default to job settings

The values as represented in the database should be supported here. For example, -2 references a venuegroup and -101 would represent the Venue Set.
If not specified, will default to job settings

Match off VenueID in the file to determine VenueID. Need to have Stores and Store groups supported in the mapping.
The values as represented in the database should be supported here. For example, -2 references a storegroup.
If not specified, will default to job settings.

True or False.
If True, import the promotion with the inactive flag on
If False, import the promotion with the inactive flag off
If no value set, set the value to false

Multibuy Only
Below are the values to match on. These are string values:

Multibuy Only
This is the qty required to trigger the products in the multibuy. For example, 2 coronas for $5 would need 2 set as the Qty Required. Values are set in hundredths

Multibuy Only
This is the multibuy price/discount
For example, if value is 5000 and Disc Percent was the Pricing Type, this would indicate 50% off items that qualify for the multibuy. Values are set in hundredths

Mix n Match Only
This determines how the price is calculated. The below options need to be supported in the file as string values:

Mix n Match Only
This is the qty required to trigger the 2nd set of products in the Mix N Match.

Mix n Match Only
This determines how the price is calculated for the second set of products in Mix n Match. The below options need to be supported in the file as string values:

Mix n Match Only
This is the ProductID/ProductGroupID that determines the products for the second set of products in Mix N Match

Mix n Match Only
This is the Product Size that will be made available in the promotion for the second set of products.
0 = All Sizes
1 = Size 1
2 = Size 2
3 = Size 3
4 = Size 4
5 = Size 5
6 = Size 6
7 = Size 7
8 = Size 8
9 = Size 9
10 = Size 10

Mix n Match Only
This is the qty required to trigger the 3rd set of products in the Mix N Match.

Mix n Match Only
This is the multibuy price/discount dependent on the ThirdMBPriceMode for the third set of products in Mix N Match.
For example, if value is 5000 and Disc Percent was the MB Price Mode, this would indicate 50% off items that qualify for the multibuy. Values are set in hundredths

Mix n Match Only
This determines how the price is calculated for the third set of products in Mix n Match. The below options need to be supported in the file as string values:

0 = All Sizes
1 = Size 1
2 = Size 2
3 = Size 3
4 = Size 4
5 = Size 5
6 = Size 6
7 = Size 7
8 = Size 8
9 = Size 9
10 = Size 10