Macola Pq Field Document

Customer Information: Tiger field Customer Code

Macola Field / Front end label Retail First three letter and last three letters of lastname. (Retail) Wholesale First three letters of the Business name and first three letters of zip code. (Whole ) (Not required for now.)

Classification

Retail (RTL, RET and TEA) one of the businees type for Retail. Wholesale (Type - Reseller) list of businesses. ANT,APP,BAB,BBS,CHA,CHM,CHU,COF,CON,COU,CRA,FRA,FUR, GAR,WEB,ZOO VIL,SPL,SEA,RUG,RHP,RAN,PHO,PHA,PET,MUS,MOC,KIT,IDE,HO S,HFU,GIF Default Credit Card always for Retail. xxx (VISA,MASTER) either of one. xxx

Payment Method Card Num Card Type Card Holder Expiry date Customer type Tax Location (Not Required for tiger) Tax code (Not Required for tiger) Profit Center Location

(‘USR’ for US retail )and USW for US wholesale ‘FS’ for (US Retail) to be updated in macola, while customer passed to macola from web. 00 – No tax, TX- tax for texas Retail customers. Tax Exempted for Wholesale US Customers. Whole Sale : For DA Profit center 001 cost center 005 Retail : For FS profit center 002 cost center 006 Retail: FS Wholesale :DA

Item information: Tiger field Stylecode

Macola Field / Front end label UPC code

Themecode Fabric1 Fabric2 Fabric3 Top category SubCategory Keywords ShopByText

Last item revision Drawing Release Drawing Revision Drawing CAD Group Item Note4 “User_Note_5” field “item_note_2” field

Inventory: The Below table show the locations to sent through the FiOTiger inventory xml files.

B2C (Retail Store): these locations are used to determine the stock of the products available in these locations for Retail. In the inventory XML file sent to the tiger, the following locations be mapped to single level.

Eg: Level1 = DA+FS+GAL+DEL , if one of the location stock is updated. It is Level1. The sum of the stock available in the locations for a particular product should be sent as a single location called Level1=100+10+20+13. Level1=143. The sum should be calculated every time when a location stock is changed. If the one of the location FGS, it is Level2. If one of the location RSV, it is Level 3. (Retail Web Site) (www.foreverinseason.com)

Tiger Locations

Macola Locations

Level – 1

=

Immediate Available

DA, FS, GAL, DEN

Level – 2

=

Available in 2 Weeks

FGS

Level - 3

=

Available in 4 Weeks

TRN - In Transit

RSV - Under Production CUT - Cutting Stock TOP - Tops Stock

Tiger Locations

(Wholesale Web Site)

Macola Locations

Level - 1

=

Immediate Available

DA

Level - 2

=

Available in 4 Weeks

FGS TRN

Level - 3

=

Available in 8 Weeks

RSV - Under Production CUT - Cutting Stock TOP - Tops Stock

Order Information: Information from Patch Quilts -

Need to send web id for the Order id and Customer web id while the order information is sent back to the tiger.

-

Documentation for the Order acknowledgment from Macola. Required from harvest.

-

Order item cancellation process from Macola, Required from harvest.

-

Invoice Process document from Macola, Patch Quilts is using oelinhst_sql , oehdrhst_sql tables. We are directly mapping to the macola invoices as the format for invoice is different for Patch quilts.

-

Also documentation on Order completion status and how that can be recognized through order XML files.

-

Patch quilts is using “oe_po_no” field for displaying the web orders in macola.