Criteria to Create the Manual Extract Report to be sent to BIW

Timing

Capture and send either daily or weekly. Set up one time with Benjamin Moore. If you would like to change the frequency contact Melissa Finnigan (melissa.finnigan@benjaminmoore.com). Consistent submission is required in order for contractors to receive their points in a timing manner. Every effort should be put in place (backup) to adhere to a regular submission cadence.

Data

Customers:

Include Customers with a Member ID (Pax ID) only

Inventory Items (Products):

Include Benjamin Moore & Co. Products only. Match using the leading digits in the UPC table in the Leading UPC Digits Tab for 10 and 12 digit UPC usage.

Example:

Leading UPC is 023906 & 23906

UPC matched would be 023906057510 & 2390605751 respectively

Fields:

See the Sample Data File and Field Description Tabs for Required (in green) and Suggested Fields. The more fields you are able to send, the more accurate the rewards calculation will be for your Contractors.

File Format

Save the file as comma delimited txt file using the naming convention below.

File naming convention

retailer_ctr_invoice_mmddyyyy.txt

Where mmddyyyy is always the current date

Replace the word "retailer" with the retailer # assigned by BIW.

Send file to BIW

Send to BIW as instructed by Patricia Bennett. After data verification period you will be released to submit txt file to secure ftp file provided by BIW.