This feature can be used when mass editing and updating price lists, descriptions and associated linesheets.
1. Update fields
In your Excel Document update the fields in Excel as required
2. Delete columns
Delete any columns where there will be no changes made, keeping only those columns where edits will be made. BE SURE TO KEEP THE SKUS YOU ARE UPDATING OR ADDING in PROPER format
3. Copy the excel data to paste changes into Blastramp
4. Go to the Advanced Tab
5. Click on Utilities
6. Click on Upload Linelist via Copy and Paste from Excel (original version)
7. Paste the Excel data
8. Paste text copied to clipboard area
9. Map the column numbers
The only column required for editing SKU information is the "SKU" column
10. Type "1"
11. Check ApparelSKU
Check this if your SKUs are in Style-Color-Size format (Apparel format) in Blastramp
12. Map the columns where edits are being made
13. Select which DC/Warehouses the edits apply to
Edits can be made to multiple warehouses simultaneously but we suggest one at a time to prevent data timeout
14. Check Exact SKU
This indicates that you are "editing" an existing SKU. Any variances in the way that the existing SKU has been typed will result in a new SKU being created.
15. Post Linelist without "Commit this data to the database?" to see if there are any errors
You can preview changes by not checking off "Commit this to the database?"
Troubleshooting Errors
If errors occur:
-
Check character limits:
- Season/Linelist = 16 characters
- Color Description = 50 characters
- Description = 200 characters
- SKU = 50 characters (style-colorcode-size)
- Check for invalid characters such as +, *, ^, ?, “, (, ).
- Verify that Sizescale, Pricelist, Season/Linelist, and Unit Type exist in Portal Settings (📍 Advanced > Admin > Portal Settings).
If errors still persist, please screenshot ENTIRE webpage showing as much data as possible and send the excel file you are working on to help@blastramp.com
16. Check "Commit to Database"
Once you are confident the changes will be correctly applied. Check "Commit" and a summary of the changes made will display.
When the import is successful, a confirmation message will appear below Post Results.
💡 Tip: To verify the import, go to:
📍 Inventory > Mass Edit > Select Season