CSV Upload file to Update Tier Pricing on Website
Budget: $30 – $250 AUD
The outcome of this project is to prepare a dynamic (linked) XLS file which can be saved as CSV file and successfully uploaded to our Magento website to update Product tier pricing.
The starting file is an xls spreadsheet which includes the Product codes and quantity brackets for pricing (tier pricing), along with associated prices - see Extract 1 - Source file - attached for example.
The finishing file is an xls spreadsheet which is linked to the starting file (so that it's dynamic) and can be saved as a csv file which is successfully uploaded to our website - see Extract 2 - Upload file - attached for example.
Notes:
1. For each Product the tier pricing should be associated with the configured Products to include the Product colour and size variations as available on our website. Example of the product variations for configurable products can be seen in Extract 2 - Upload file.
2. For all tier pricing where the price is constant from one qty bracket to another, the tier needs to be eliminated from the upload file. For example if qty 5 pricing = qty 10 pricing for any product, the qty 10 pricing should NOT be included in the upload file.
This project is to setup the file for a selection of 1 Brand of Products represented on our website only which requires updating.
The starting file is an xls spreadsheet which includes the Product codes and quantity brackets for pricing (tier pricing), along with associated prices - see Extract 1 - Source file - attached for example.
The finishing file is an xls spreadsheet which is linked to the starting file (so that it's dynamic) and can be saved as a csv file which is successfully uploaded to our website - see Extract 2 - Upload file - attached for example.
Notes:
1. For each Product the tier pricing should be associated with the configured Products to include the Product colour and size variations as available on our website. Example of the product variations for configurable products can be seen in Extract 2 - Upload file.
2. For all tier pricing where the price is constant from one qty bracket to another, the tier needs to be eliminated from the upload file. For example if qty 5 pricing = qty 10 pricing for any product, the qty 10 pricing should NOT be included in the upload file.
This project is to setup the file for a selection of 1 Brand of Products represented on our website only which requires updating.