Overview
Style Sync is a flat-file integration. A Style Sync integration can add, update, drop, or delete styles in your JOOR account directly from your ERP. Observing JOOR's best practices will enable fast and accurate data uploads.
Tips
- Style Sync Flat File Integration has the capability to create linesheets and load images
- Files must not exceed 20MB.
- File name must be specified for the integration to be able to pick up new files. We recommend including the word “styles” or “SKU”, along with a timestamp.
- After receiving a finalized file format, we recommend two weeks of testing by placing files on an FTP and reviewing changes on the JOOR website. This helps ensure all functionality is working properly
- You can find a list of recommended testing scenarios here - Use this list as a guideline as you test different scenarios that are relevant to your business. Once all relevant tests have been executed successfully, your integration should be ready to be activate on your Production account
- If you are using Case Packs and/or Style Tags both need to be set up under your Style Settings in JOOR prior to loading the file via integration
- Please note that any price type set up in JOOR will be displayed within each style in your account.
- When updating styles, there’s no need to send your whole collection each time, just send style/colors that have changed.
Most Common Errors
Amendments to Style Data
After the integration goes live, no manual edits should be made to styles data on your JOOR account. Manual edits have the potential to cause integration issues.
If modifications need to be made to the integration after it is live, this must be first communicated to your Customer Success Manager. Please also provide a sample file and our team to review.
Once the JOOR team approves this modification, the production integration will be updated and the new files may be sent.
- To drop a style from all linesheets, you’ll need to pass through a Drop action code record with linesheet name field blank.
- To change color name, pass through a Drop/Delete action code for the old color name, then Add for the new color name.
- To remove a size you can either
- Send an update record with all sizes you wish to display. Remaining sizes will be marked inactive
- Include a Size Active Column. If any value is populated in this column for a specific row, the size will remain active. If there is no value populated for a row, the size will be marked inactive
Style Testing Scenarios
Basics:
- Add a new connection
Connection Specific Data:
- Add a payment method
- Update a payment method
- Add a shipping method
- Update a shipping method
- Add a new address (billing & shipping)
- Update an existing address (billing & shipping)
- Add an alias
- Add additional address to existing connection
- Add a discount
- Update a discount
- Add a company number
- Update a company number
- Add a door
- Update a door
- Add a buyer
- Update a buyer
Available Fields
JOOR Field Name | Template Field Name | Required | Value | Max | Description |
style_number | Style Number | N | Text | 45 | Code used to signify styles. If not using UPC, this field is required. |
style_id | Style ID | N | Integer | 10 | The JOOR unique internal ID for a style. |
color_name | Color Name | N | Text | 100 | The display name of the color. If not using UPC, this field is required. |
color_code | Color Code | N | Text | 100 | The code associated with the color name. |
style_color_id | Style Color ID | N | Integer | 10 | The JOOR unique internal ID for a style/color combination. |
size_name | Size Name | N | Text | 255 | The individual size to which units are allocated. If not using UPC, this field is required. |
size_code | Size Code | N | Text | 25 | The code associated with the size name. |
upc | UPC | Y | Text | 100 | The universal product code for the designated SKU (Style Number, Color, Size). |
quantity | Quantity | Y | Integer | 10 | The number of inventory units available to be ordered. |
warehouse | Warehouse | N | Text | 100 | The warehouse in which the inventory positions should be stored. Must be set up in JOOR before loading. |
date | Date | N | String | 10 |
Date assigned to the inventory positions. Can be in YYYY-MM-DD or MM- DD-YYYY format. |