http://www.mapleridgefarmscoupons.com
Maple Ridge Farms - Help

Correct Format For Electronic Lists


Please read carefully before preparing mailing list.

 


  1. Only one shipping list accepted per order.


  2. All hidden rows/columns must be removed from the spreadsheet for factory to process. Lists that are not formatted correctly will be returned and considered not complete.


  3. Lists containing more than one recipient per address location will be considered and prepared as Individual Drop Shipments at $4.00 (G) per carton plus shipping charges.


  4. All addresses must be submitted in a single worksheet, document or file.


  5. We will accept MS Excel or MS Word in PC format.


  6. Excel files must use the exact field names shown below. The cells must be formatted as text. MS Word files must have the list in a table with the first row containing the field name for the column from the list below.


  7. Comma and tab delimited files must have a header row with the field names from below.


  8. When supplied list does not match the quantity on the purchase order, factory will adjust order to match the quantity on the shipping list.

            Below is an example of a list in MS Excel format.

            Top row indicates maximum field size.

 

29

30

30

30

25

2

10

20

7

Name

Company

Addres1

Address2

City

State

Zip

Item

Qty

John Smith

ABC Co.

2nd Floor

123 4th St.

Milwaukee

WI

54455

K102

1

Sales Dept

A+ Sales

1 Easy St

 

Beverly Hills

CA

90210

GN121

2

 

XYK Inc.

Our Bldg.

9 Main St

Memphis

TN

38118

K102

1

 

Either Name or Company may be blank, but not both. Address 2 may be blank. If the item is not the same for all addresses, the 'Item' field must include the Maple Ridge Farms item number. If the quantity per address varies, the 'Quantity' field must include the number of units for that address.



Other Help
Proofs
Artwork Information
Gift Cards
Individual Drop Shipment
Addresses
Correct Format For Electronic Lists
Changes To Orders
Additions To Orders
General
Production & Shipping Information
UPS Ground - Time In Transit Map
Stock Designs - Firebranding
Stock Designs - Foil Stamped Ribbon
Typestyles
Extra Services