Garment Database

Open JOB#184

Not shipped126

Unpaid invoices31

Revised exports7

WIP Overview

Date-based attention from the latest accepted WIP workbooks.

Loading WIP...

WIP Status

Current Style health and latest accepted workbook by WIP.

Client Year 0 WIPs

	Client	Year	WIP	Region	Source	Styles	Active JOB#	Delayed	Missing	On Track	Not Started	Last Upload / Update	Status
Loading WIP records...

Client Year Summary

BPO, SPO, Style, and Division sales totals by EX FTY period.

Client	JOB#	SPO JOB#	Total Styles	Total Qty	Total Sale Price

Recent JOB# Activity

Created or modified today.

	JOB#	Client	Destination	Season	Year	Style	Status	Factory export

Shipping Docs

Invoice# based shipment work.

Deleted JOB# List

JOB#	Client	Client PO#	Style	Deleted Date	Actions

JOB# Entry

No BPO selected

JOB# Internal Code Client Client Contact Client Tel Client Email Client PO# Client PO#2 Client PO#3 Season Year Season Destination Terms Billing Address Warehouse Address Factory Made in Shipping Method Payment AR Payment Received Date Entered Date EX FTY In House Delivery PO Cancellation Roots OB Date

Invoice# AR Invoice# Shipped Qty Shipped Date

Style

Style search Available Styles

Division
Category
Body
Style Fabric Part 1
Style Fabric 1
Fabric composition 1
Style Fabric Part 2
Style Fabric 2
Fabric composition 2
Style Fabric Part 3
Style Fabric 3
Fabric composition 3
Fabric weight
HS CODE
中文名称

Special Instructions

Shipping Marks

Internal Revision Details

Revision Details For the Factory

Color / Size / Price

Use row + to insert the next available size within the selected size group.

Size Group

	Color	Color Code	UPC	SKU	Size	Qty	Sale Price					AP Price USD $	LDP Price USD $	Doc Price USD $	Subtotal Sale

Total Qty0

Total Sale$0.00

Total AP$0.00

Gross Profit$0.00

First Export-

Comments

Internal comments for this JOB#.

Comment

Comment History

Newest comments first.

Split BPO

Move quantities from the current JOB# into a new JOB#.

New JOB# Revision Note

Split Qty 0 · Original Remaining 0

Move Full Row	Color	Color Code	Size	Original Qty	Split Qty	Remaining Qty

WIP Overview

Review production progress by JOB# and stage.

Workbook Mapping Preview

Select a workbook to inspect its worksheets and field mapping.

WIP Workbook

	Worksheet	Detected Type	Header Row	Rows	Mapped	Customer Fields	WIP Master	Review
No workbook preview loaded.

Preview the workbook before importing.

Import History

View saved snapshots, restore one as a new version, or delete old history.

Version	Imported	User	File	Worksheets	Rows	Linked	Unmatched	Conflicts	Actions
No import history loaded.

Version details

WIP Directory

Loading WIP records...

		WIP Name	Year	Type	Region	Worksheet	Styles	JOB#	Missing	Delayed	Last Update	Status
Loading WIP records...

Style Search Internal Code

Roots WIP Master

Import the protected customer workbook as the source of truth. Fixed rows and locked cells are validated before any data is saved.

Season Master Season Year Season Import Type Roots WIP File

Import History

Select an existing Season Master to review uploaded versions.

Version	Import Type	File	Rows	Uploaded By	Uploaded At
No Roots WIP Season Master selected.

Style / JOB# Links

Select an existing Season Master to review automatic links.

Style → Linked JOB#

Select an existing Season Master to see each Style's linked JOB# list.

System Style	Description	Linked JOB#	WIP Rows	Linked Rows	Waiting	Conflict
No Roots WIP Season Master selected.

Row	Roots Style#	Vendor Style#	PO#	Colour	System Style	JOB#	Status	Note
No Roots WIP Season Master selected.

Client WIP Preview

Select one Client and Year, then include all visible WIPs or a checked combination.

Progress Matrix

No WIP search loaded.

Factory WIP Search

Search assigned production JOB# records by JOB#, internal_code, PO#, or Style.

Search

JOB# Review

No Factory WIP search loaded.

JOB#	Internal Code	Client	Client PO#	Destination	Style	Style Composition	Fabric Weight	Qty	Current Stage	Status

WIP Progress

Changes entered here are saved to every JOB# currently loaded in JOB# Review.

Stage	Status	Planned Date	Actual Date	Comments	Updated By

No Active Workspace

Factory WIP is temporarily disabled. Please contact an administrator if access is required.

Generate Roots SPO

Preview Marketing Sample (PO# 36) and Photo Sample (PO# 67) records before saving.

Loading preview...

	Client PO#	Sample Type	Source JOB#	Style / Classification	Colors	Size / Qty per Color	Total Qty	Status / Notes
Loading preview...

Client CodeClient NameAbbreviationDepartmentCountryDestinationContactTelEmail

Editable Client Records

Billing Address Warehouse Address Shipping Marks

Manage Client

Select a Client Name to review every Client Code, destination, and warehouse address.

Client Code	Client Name	Destination	Warehouse Address

Style ID Client Season Season Year Style# Style Name Division Knitted / Woven Category Body

Style Fabric Part 1Fabric Code 1Style Fabric 1Fabric composition 1

Style Fabric Part 2Fabric Code 2Style Fabric 2Fabric composition 2

Style Fabric Part 3Fabric Code 3Style Fabric 3Fabric composition 3

Fabric weight

HS CODE

补充码中文名称英文对照 Notes Active / inactive

Style Colors

Color master data only

	Color	Color Code	UPC	SKU	Comments	Active

Destination Price Matrix

Use All Destinations as the default price. Add country rows only when a destination needs a different price.

	Color	Destination	Sale Price	Confirm	Comments

Shipping Forecast

0 JOB#

	Submit	JOB# / SPO#	Internal Code	Client	Destination	Style	Factory	Qty	Factory RMB Price	Factory price settled in USD	Expected Factory Date	Status	Submitted	Notes

SPO Entry

SPO Master List below left navigation

SPO#SPO Entered DateClientDestinationClient SPO#SPO Invoice#Shipped QtyAR Invoice#SPO PaymentAR PaymentSeason YearSeasonBillingWarehouse AddressEX FTYShipping MethodMultiplier

Style

Available Styles

Division
Category
Body
Style Fabric Part 1
Style Fabric 1
Fabric composition 1
Style Fabric Part 2
Style Fabric 2
Fabric composition 2
Style Fabric Part 3
Style Fabric 3
Fabric composition 3
Fabric weight

SPO Special Instructions

SPO Revision Details

Color / Size / Price

Use row + to insert the next available size within the selected size group.

Size Group

	Color	Color Code	UPC	SKU	Size	Qty	SPO Sale	Actual Sale	Subtotal

SPO Total Qty50

Total SPO Sale Price$290.00

SPO Master List

Invoice Overview

All Invoice# records are generated from linked JOB# records.

Invoice Year

All Invoice#0

Current View0

26MZ UsedNot used

27MZ UsedNot used

Active MZ Series-

Next Number-

Selected Invoice-

Linked JOB#0

Total AP$0.00

PaymentUnpaid

	Invoice# ↕	AR Invoice# ↕	JOB#	Clients	Destinations	Total AP	Payment ↕	AR Payment ↕	Shipment Check

	JOB#	AR Invoice#	Style#	Color	Color Code	Client	Destination	Client PO#	Subtotal Qty	Shipped Qty	JOB# Ex Rate	AP Price	LDP Price	Doc Price	Total	Payment	AR Payment
No Invoice# has been assigned yet.

Invoice#Local Charge CurrencyLocal Charge RMB¥Local Charge Ex RateLocal Charge USD$

Select JOB# for PDF Export

	JOB#	Client	Destination	Client PO#	Style	Qty	Export	Modified Date	Export Date	PDF File

No BPO selected.

Select SPO# for PDF Export

	SPO#	Client	Destination	Client SPO#	Style	Qty	Export Status	Export Date	SPO Entered Date	EX FTY	PDF File

Invoice Operations

No Invoice# selected

	Type	JOB# / SPO#	Client	Destination	PO#	Style	Qty	Shipped Qty	Expected Factory Date	Shipped Date	Booking Date	Status
Select an Invoice#.

Customs Classification

Select an Invoice#.

Shipping Documents

Select an Invoice#.

Booking List

Booking

Invoice

Customs

New / Updated Shipping Orders

	Type	JOB# / SPO#	Client	Destination	PO#	Style	Qty	Expected Factory Date	Submitted By	Submitted At	Status	Invoice#

Search Format Converter

Field 1

Field 2

Post-Import Check

Run after Client, Style, JOB#, or SPO imports to check database links, totals, quantities, price formulas, and Invoice# rules.

Status	Area	Check	Count	Details
Run check after importing data.

Client Import

Preview CSV records before writing them to the database. One row equals one Client / Destination / Warehouse record.

No file loaded

Client CSV File Duplicate Mode

Required columns: Client Name, Destination, Warehouse Address. Client Name must already exist in Client Management; Abbreviation and Department are filled from that master record. Billing Address, Warehouse Address, and Shipping Marks convert semicolon ; into line breaks.

Preview

Review errors and duplicates before import.

Row	Action	Client Name	Abbr	Country	Destination	Contact	Tel	Email	Billing Address	Warehouse Address	Shipping Marks	Active	Messages

Style Import

Import Style header, Style Colors, and Destination Price Matrix after Client records are ready. One CSV row equals one Style Color / Destination Price line.

No file loaded

Style CSV File Duplicate Mode

Fixed column order: Style ID, Client, Season Year, Season, Style#, Style Name, Division, Category, Body, Knitted / Woven, Style Fabric Part 1, Style Fabric 1, Fabric Composition 1, Style Fabric Part 2, Style Fabric 2, Fabric Composition 2, Style Fabric Part 3, Style Fabric 3, Fabric Composition 3, Fabric Weight, Notes, Active, Color, Color Code, UPC, SKU, Color Comments, Destination, Sale Price, Confirm, Price Comments, Color Active. Leave Style ID blank to create a new Style.

Style Preview

Existing Styles are grouped by Style ID. Blank Style ID rows are grouped as new Styles.

Row	Action	Style ID	Client	Season	Style#	Style Name	Division	Category	Body	Fabric 1	Color	Destination	Sale Price	Confirm	Messages

BPO Import Preview

Preview JOB# header and Color / Size / Price rows after Client and Style records are ready. Import only after rows show no errors.

No file loaded

JOB# CSV File Duplicate Mode

Fixed column order: JOB#, Client, Season Year, Season, Destination, Warehouse Address, Client PO#, Client PO#2, Client PO#3, Style#, Style Name, Terms, Made In, Shipping Method, Received Date, Entered Date, EX FTY, In House Delivery Date, PO Cancellation Date, Roots OB Date, Factory, Special Instructions, Size Group, Color, Color Code, Size, Quantity, UPC, SKU, Sale Price, Factory RMB Price, Factory USD Price, Ex Rate, Factory Price Settled in USD, AP Price, Shipped Qty, Invoice#, Shipped Date, Payment.

JOB# Preview

Rows with the same JOB# are merged. Nonblank cells update existing data; omitted Color / Size rows remain unchanged.

Row	Action	JOB#	Client	Season	Destination	PO#	Style#	Color	Color Code	Size	Qty	Sale Price	Invoice#	Messages

SPO Import Preview

Preview SPO header and Color / Size / Price rows after Client and Style records are ready. Import only after rows show no errors.

No file loaded

SPO CSV File Duplicate Mode

Fixed column order: SPO#, Client, Season Year, Season, Destination, Warehouse Address, Client SPO#, SPO Invoice#, SPO Payment, Style#, Style Name, Shipping Method, Entered Date, EX FTY, Size Group, Multiplier, SPO Special Instructions, SPO Revision Details, Color, Color Code, Size, Quantity, UPC, SKU, SPO Sale Price.

SPO Preview

Rows with the same SPO# are grouped. If SPO# is blank, rows are grouped by Client + Client SPO# + Style# for future automatic numbering.

Row	Action	SPO#	Client	Season	Destination	Client SPO#	SPO Invoice#	SPO Payment	Style#	Color	Color Code	Size	Qty	SPO Sale Price	Multiplier	Messages

User Management

Administrator can add/delete users and change roles. Other users can only review this table.

Username	Display Name	Password	Role	Factory	Client Access	Price Access	Navigation Limits	Active

Invoice Numbering

Controls the two-digit year prefix used by automatic Invoice# assignment.

Invoice# Year Prefix

Automatic format27MZ001, 27MZ002...

Document / Export Settings

Shared company, port, manufacturer, and stamp settings used by PDF export templates.

Company / Seller

Company Chinese Name Company English Name Company Address Default Seller Name Default Seller Address

Booking Defaults

Booking Shipper Name Booking Shipper Address Port of Loading Port of Loading Uppercase Country of Origin

Customs / Stamps

Customs Domestic Entity Code Customs Overseas Consignee Customs Overseas Consignee Address Red Stamp Image URL Blue Stamp Image URL

Document Profiles

Profile Name Client Document Type Active

Seller Name Seller Address Consignee Name Consignee Address Ship To Name Ship To Address Buyer / Sold To Name Buyer / Sold To Address Notify Party #1 Notify Party #2 Manufacturer Details Port of Loading Port of Discharge Country of Origin Vendor Code

Client Management

Client names and accounting codes used by Client records and USA Accounting exports.

Client Name	Abbreviation	Department	Client Records

Manufacturing Plants

Factory master data used by JOB#, Factory WIP, and future Roots EDI.

Code	Name	Full Name	Abbr	Country	Made In	Type	Roots EDI	EDI Factory Code	Contact	Email	Address	Active	Notes

Factory WIP Stage Access

Checked stages are visible and editable on the Factory WIP page.

Seq	Stage	Factory Visible / Editable

HS CODE List

Style auto-match reads this list by English description combination.

HS CODE	补充码	中文名称	英文对照

Customs Declaration Templates

Local declaration elements by HS CODE.

HS CODE	中国商品名称	品牌类型	出口享惠情况	申报要素	来源日期

Lookup Lists

Delete Undo Delay seconds

Season

Season Year

Made in

Division

Category

Body

Style Fabric Part

Style Fabric

Fabric composition

Shipping Method

Terms

Country List

Destination List

Size Group

Saved Searches

Garment Database

WIP Overview

WIP Status

Client Year Summary

Recent JOB# Activity

Shipping Docs

Deleted JOB# List

Cancel JOB# List

JOB# Entry

Style

Special Instructions

Shipping Marks

Internal Revision Details

Revision Details For the Factory

Color / Size / Price

Comments

Comment History

WIP Overview

Workbook Mapping Preview

Import History

Version details

WIP Directory

Roots WIP Master

Import History

Style / JOB# Links

Style → Linked JOB#

Client WIP Preview

Progress Matrix

Factory WIP Search

JOB# Review

WIP Progress

No Active Workspace

Customize Columns

Editable Client Records

Manage Client

Style Colors

Destination Price Matrix

Shipping Forecast

SPO Entry

Style

SPO Special Instructions

SPO Revision Details

Color / Size / Price

Customize SPO Columns

SPO Master List

Invoice Overview

Select JOB# for PDF Export

Select SPO# for PDF Export

Invoice Operations

Customs Classification

Shipping Documents

Customize Booking List

New / Updated Shipping Orders

Search Format Converter

Post-Import Check

Client Import

Preview

Style Import

Style Preview

BPO Import Preview

JOB# Preview

SPO Import Preview

SPO Preview

User Management

Invoice Numbering

Document / Export Settings

Company / Seller

Booking Defaults

Customs / Stamps

Document Profiles

Client Management

Manufacturing Plants

Factory WIP Stage Access

HS CODE List

Customs Declaration Templates

Lookup Lists