TABLE OF CONTENTS
Overview
Purpose of Process | Bulk Processing of Product Unit Adjustments |
Description of Process | Maze uses their YDE portal to extract total sales within a period at stores. This needs to be accounted for to clear stock (Realise NETT Sales) in Sync via FG Unit adjustments for the NETT sales per store. This process can be done in Bulk via a CSV template loaded to Dropzone. |
Special Notes | - Files will be processed in the order in which they are loaded if there are multiple files in one run. - Each YDE store is a separate warehouse in Sync - RMS SKU must be captured in Sync in the Product Stock SKU filed - Maze to follow the rest of the custom process for YDE Consignment Sales- ie warehouse transfers |
| Known Risk | - If YDE RMS SKU is not captured in Sync or is incorrect the adjustment will fail - If Store name does not match Sync Warehouse exactly the adjustment will fail |
| Schedule | Once a day at 8pm |
Detail
1. Ensure ALL YDE RMS Sku's are capture in Sync on the Product Stock SKU field
2. Use the YDE Sales Extract from the YDE portal to extract NETT sales qty Per YDE store Per SKU
3. Capture required NETT adjustment per store per SKU on the Bulk Adjustment CSV template (Attached)
- Do not rename add or remove columns
- Add a row for each SKU where adjustment is required
4. Save file as CSV (close file on your PC before trying to load to Dropzone)
5. In Sync navigate to 'Dropzone'
6. Click add new
7. Click the 3 dots next to file location
8. Choose your CSV file to upload
9. Specify file name- this can be anything
10. Select 'YDE Store Adjustments' as the category
11. Click ok to import file
12. The file will appear in the file listing (filter in the Dropzone view as required)
- Files cannot be amended once added to drop zone
- Delete the incorrect file BEFORE processing at 8pm daily
13. CSV files will be processed once per day at 8pm
14. Once the file has been processed and adjustments have been made and email confirmation will be sent out and a file with the details will be attached.
15. Review email confirmation for any errors- these should be manually corrected OR included in another batch upload
NB View the below Giff for step by step
CSV File mappings
| COLUMN | SYNC MAPPING | NOTES |
| Rms SKU | SKU | This is the 'unique identifier' used by the file processing. YDE RMS SKU |
| Store Name | Warehouse | Must match the Sync YDE warehouse name exactly |
| Units Sold | Adjustment units | NET sales per store per SKU. Negative value (-1) will result in Stock Adj In- ie Units returned to YDE Positive value (1) will result in Stock Adj Out- i.e. units sold from YDE Adjustment will be done out of or into the Job with the MOST stock if SKU exists in multiple Jobs |
Do not remove or rename any columns, All columns must be capturedAdjustment Mapping in Sync
| Move Type | User | Reference | Adjustment Reason | Comment |
| Stock Adj Out | bulkadjustments | YDE Bulk Adjustment | YDE Net Sales | YDE Bulk Adjustment |
| Stock Adj In | bulkadjustments | YDE Bulk Adjustment | YDE Net Sales In | YDE Bulk Adjustment |
Confirmation email with error notifications
Confirmation email will be sent to the email address captured for the user who loaded the file.
- If no email exists for the user then the default will be used. Default is set to Amanda
| ERROR/ISSUE | CAUSE | CORRECTION |
| No Stock on Hand To Adjust | - No SKU captured - Not enough stock on hand to adjust out | - Add RMS SKU into Sync in the Product SKU field - Correct stock in warehouse & manually adjust or process a new file |
| Warehouse Does Not Exist In Sync | - Warehouse does not exist in Sync - Warehouse on import does not match SYnc | - Add new warehouse into SYnc & complete corresponding stock movements required - Correct spelling of warehouse on import file and reprocess OR adjust manually |
Change Log
DATE | TICKET | DESCRIPTION |
| 06 June 2025 | 6770 | Deployment to live |
|
|
|
|
|
|