SanMar Price List Converter - InkSoft Transform

Select the SanMar price list CSV file to convert it for ShopWorks import.
Processed locally in your browser - no upload needed, works with any file size.

Choose File No file selected

Conversion Complete

0 original rows → 0 converted rows

Preview (First 10 Rows)

ID_Product	Description	Price_Unit_Piece	BrandName	Limit01-04	Limit05	Limit06

Conversion Logic

ID Generation

Regular sizes (S, M, L, XL): Base style ID (e.g., ST940)
2XL, 3XL, 4XL, etc.: STYLE_2X, STYLE_3XL (e.g., ST940_2X, ST940_3XL)
Other sizes (XS, OSFA, Youth): STYLE_SIZE (e.g., ST940_XS, ST940_YM)

Size Limit Flags

Size	Slots 1-4	Slot 5	Slot 6
S, M, L, XL	Allowed	Blocked	Blocked
2XL	Blocked	Allowed	Blocked
XS, 3XL, 4XL, OSFA	Blocked	Blocked	Allowed

Description Formatting

Style number removed: SanMar titles end with the style number (redundant since it's in ID_Product) — automatically stripped
Size prepended for non-standard sizes: Sizes other than S, M, L, XL get "Size 2XL - " etc. before the description

Example: "Jerzees - Dri-Power T-Shirt 29M" → "Size 3XL - Jerzees - Dri-Power T-Shirt"