Garment Database Prototype

Open JOB#184

Not shipped126

Unpaid invoices31

Revised exports7

WIP Overview

Active production JOB# health from the WIP progress matrix.

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

JOB# and SPO totals by EX FTY year.

Client	JOB#	SPO JOB#	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

Revised after export

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 Received Date Entered Date EX FTY In House Delivery PO Cancellation Roots OB Date

Invoice# Shipped Qty Shipped Date

Style

Style search Available Styles

Division: Womens
Category: Tees
Body: Top
Style Fabric Part 1
Style Fabric 1
Fabric composition 1: 100% Organic Cotton
Style Fabric Part 2
Style Fabric 2
Fabric composition 2
Style Fabric Part 3
Style Fabric 3
Fabric composition 3
Fabric weight: 155g/m2
HS CODE
中文名称

Special Instructions

Shipping Marks

Internal Revision Details

Revision Details For the Factory

WIP Progress

JOB# level production progress. Factory-editable stages are marked in the first column.

Factory	Stage	Status	Planned Date	Actual Date	Comments	Updated By

Comments

WIP and JOB# related comments. Batch WIP comments are shown here automatically.

Comment Requires escalation Boss attention required

Comment History

Newest comments first.

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-

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	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.

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.

Comments History

History from Batch WIP Update Comments for the selected internal_code.

Batch WIP Update

Update the selected JOB# records.

Selected 0 JOB#

Internal Code Assign new internal_code Stage

Status

Planned Date Actual Date

Comments

Requires escalation Boss attention required

Manage Internal Code

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

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

Sales users submit expected ship dates and uniform Factory RMB prices before shipping batches are created.

0 JOB#

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

SPO Entry

SPO Master List below left navigation

SPO#SPO Entered DateClientDestinationClient SPO#SPO Invoice#SPO PaymentSeason YearSeasonBillingWarehouse AddressEX FTYShipping MethodMultiplier

Style

Available Styles

Division: Womens
Category: Tees
Body: Top
Style Fabric Part 1
Style Fabric 1
Fabric composition 1: 100% Organic Cotton
Style Fabric Part 2
Style Fabric 2
Fabric composition 2
Style Fabric Part 3
Style Fabric 3
Fabric composition 3
Fabric weight: 155g/m2

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

Selected Invoice26MZ052

Linked JOB#0

Total AP$0.00

PaymentUnpaid

	Invoice# ↕	JOB#	Clients	Destinations	CTNS	T.G.W	T. MEAS	Total AP	Payment ↕	Shipment Check

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

	JOB#	Style#	Color	Color Code	Client	Destination	Client PO#	Subtotal Qty	Shipped Qty	JOB# Ex Rate	AP Price	LDP Price	Doc Price	Total	Payment
	RT260000	Roots	Canada	445848-35	2250	2250	$3.60	$8,102.25
	BB260271	Boot Barn	USA	677674	1800	1800	$6.70	$12,060.00

Select JOB# for PDF Export

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

BULK PRODUCTION ORDERExport Date: 2026-06-11

JOB#RT260000

Client: RootsSeason: Summer 2026Destination: CanadaClient PO#: 445848-35EX FTY: 2026-01-19Shipping Method: OCEANMade in: MADE IN CHINA

Warehouse Address: ROOTS EDWARDS DC, 1230 Mid-Way Blvd, Mississauga, ON

Style: 38031266/260438036836 LES FLEURS T-SHIRT | Womens Knitted Tee Shirt | Single Jersey 100% Organic Cotton | 155g/m2

Color	Color Code	UPC	SKU	SIZE									Total
Color	Color Code	UPC	SKU	2XS	XS	S	M	L	XL	2XL	3XL	4XL	Total
CHARCOAL BLACK	CN1	198712535801...	RT-CN1	61	311	499	557	453	264	56	38	11	2,250

BULK PRODUCTION ORDERContinuation

JOB#RT260000

Color	Color Code	UPC	SKU	SIZE									Total
Color	Color Code	UPC	SKU	2XS	XS	S	M	L	XL	2XL	3XL	4XL	Total
IVORY	IV2	198712535900...	RT-IV2	24	116	210	235	198	91	22	7	2	905
TRUE NAVY	NV4	198712535960...	RT-NV4	18	104	196	220	184	86	19	5	0	832
FOREST GREEN	FG7	198712536021...	RT-FG7	12	88	170	192	151	70	15	4	0	702
HEATHER GREY	HG5	198712536083...	RT-HG5	20	130	215	244	188	76	17	6	1	897

Special Instructions

Tier 1 Transaction Certificate is required for products made with PFM material.

Revision Details For the Factory

2026-06-11 Manager Initial order.

Select SPO# for PDF Export

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

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: 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.

Style Preview

Rows with the same Client + Season Year + Season + Style# are grouped into one Style.

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

JOB# 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 grouped. If JOB# is blank, rows are grouped by Client + Client PO# + Style# for future automatic numbering.

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

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	补充码	中文名称	英文对照

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

WIP Alerts

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

WIP Progress

Comments

Comment History

Color / Size / Price

WIP Overview

Workbook Mapping Preview

Import History

Version details

WIP Directory

Roots WIP Master

Import History

Style / JOB# Links

Client WIP Preview

Progress Matrix

Comments History

Factory WIP Search

JOB# Review

WIP Progress

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

Customize Booking List

Invoice Overview

Select JOB# for PDF Export

Select SPO# for PDF Export

Search Format Converter

Post-Import Check

Client Import

Preview

Style Import

Style Preview

JOB# Import Preview

JOB# Preview

SPO Import Preview

SPO Preview

User Management

Document / Export Settings

Company / Seller

Booking Defaults

Customs / Stamps

Document Profiles

Client Management

Manufacturing Plants

Factory WIP Stage Access

HS CODE List

Lookup Lists