Overview
– It’s crucial to maintain accurate Purchase Prices, as they directly impact the sales profit and loss statistics.
– You can edit the Average Purchase Price of your products in Ginee’s Stock Management
– If you input different Purchase Prices every inbound, Ginee will calculate the Average Purchase Price
Ginee’s calculation to get the Average Purchase Price:
Average Purchase Price = (Current Inbound Quantity * Current Inbound Purchase Price + Original Quantity * Original Purchase Price) / (Current Inbound Quantity + Original Quantity)
– Sample:
Average Purchase Price = [10 (Current Inbound Quantity) * 150 (Current Inbound Purchase Price) + [10 (Original Qty) * 100 (Original Purchase Price)] / 10 (Current Inbound Quantity) + 10 (Original Qty)
Average Purchase Price = [10*780 + 10*100 / 20]
Average Purchase Price = 125
However, you can take the following steps to update the average purchase price.
Steps
A. Single Update
1. Go to Stocks > Stock List > Click the pencil icon beside the Average Purchase Price
2. Input the New Average Purchase Price > Click “Confirm”
B. Bulk Update (Import to Update)
1. Go to Stocks > Stock List > Click“Import/Export” > Edit Average Purchase Price
2. Click “Download Template”
3. Fill in the required information (These are the column headers in red font)
IMPORTANT: Please remove the contents of the first row before use
a. [Required] MSKU
b. [Required] Warehouse Code (Go to Warehouse > Warehouse List to determine the warehouse code. If you only have 1 warehouse, the WH Code is 001.)
c. [Optional] Location Number/Shelf Number (Go to Warehouse > Shelf Management to determine the Shelf Number to which you will add spare stocks. If you don’t fill in, Ginee will select the location with the largest Available Stock.)
d. [Required] Average Purchase Price (Should be between 0 – 1,000,000,000)
4. Save the file
5. Go back to Ginee OMS > Edit Average Purchase Price window > Click “Import File” > Open the template > Upload
6. Check if the import has been successful
a. Import Success
b. Import failed
1.) Click “Download Failed Data”
b.) Check the “Reason’ column. Then, you need to re-import the file with correct information