Striven HELP
How to create a Bremick Price File
- Adam Sheean
Follow these instructions to create a BREMICK price file.
As Bremick have weird Purchase Unit calculations, I have put some formulas in to determine the Purchase Unit and barcode.
The original file should look something like this:
Clean it up so it is a table, so it looks like this:
Add 3 new columns to end:
Striven Purchase Unit | Striven Barcode | Striven Alternate Barcode |
|---|---|---|
=IF(K2>H2,"1",E2) | =IF(G2="",F2,G2) | =IF(AND(F2="",G2=""),"",IF(F2=M2,G2,F2)) |
If “RRP” > “Invoice Price” then “1” else its the “Pk Qty” | If “EAN Each” is blank then its the “EAN Box” else its the “EAN Each” | If “EAN Box” is blank and “EAN Each” is blank then its blank, else if “EAN Box” is the same as “Striven Barcode” then its “EAN Each” else “EAN Box” |
| HINT: If the “0”s appear just sort the column, then remove all the “0”s manually. | HINT: If the “0”s appear just sort the column, then remove all the “0”s manually. |
Put it into our standard layout.
Add the following columns to the Standard Layout:
Striven Template Column Name | Bremick Master File Column Name |
|---|---|
SupplierPartNo | Code |
Barcode | Striven Barcode |
Description | Description |
Ex GST Cost | Invoice Price |
Recommended Retail | RRP |
Minimum Order Qty | MOQ |
PurchUnit | Pk Qty |
AlternateBarcode | Striven Alternate Barcode |
PurchaseUnitCode | Pk Type |
SalesUnitCode | Priced Per |
CartonQty | Pk Qty |
Load this file into the Load Supplier File
Ensure it comes up in the Load screen and you tick the Purchase Unit option at the top.
NOTES From Hoadleys Load - 22/11/2023
If “Pk Type” = BULK, then do the following:
Divide the COST and RETAIL by the Purchase Unit (that we have calculated).
If the Purchase Unit > 1 then divide the RRP by P/U, otherwise used the original RRP.
Wants to stock as an EACH instead of the
Then set those items to have a P/Unit of 1.
Note:
This was created for Iluka.
Sample File:
