Store Stock
Stores and Locations
In IXO Commerce, stock is managed at the Store level, with each Store potentially having multiple Locations.
Each Location can be set to one of the following statuses:
- Available: Stock is available for order fulfillment.
- Unavailable: Stock is not available for Sales Order fulfillment (typically used for damaged stock).
- Reserved: Stock is reserved and cannot be used for Sales Order fulfillment.
Units of Stock
For each item (e.g., a Variant or a Unique Stock Record), there may be multiple units of stock. These units are organized by:
Date Received: When the stock was added to the system (typically the date it was received on a Purchase Order)
Cost Price: The cost to associated with that unit of stock.
This allows for multiple units of the same item to have different cost prices and dates of receipt.
Adding Units of Stock
Units of stock can be created through:
- Manual adjustments
- Stock take
- Purchase ordering
Removing Units of Stock
Units of stock can be removed through:
- Manual adjustments
- Stock take
- Supplier returns
- Sales Order fulfillment
Practical Examples
Example 1: Multiple Units of Stock
- Storing the age of a unit of stock:
- Variant “Gadget A” has 5 units of stock in the Bristol Store
- 2 units were received on the 01/05/2024
- 3 units were received on the 24/02/2024
- Storing different Cost Prices:
- Variant ‘small-pink-shirt’ has 5 units of stock in the London Store
- 1 is stored at a Cost Price of £5
- 3 are stored at a Cost Price of £6.50
- 1 is stored at a Cost price of £7
- Total value of the stock holding is £31.50
Example 2: Stock Adjustments
- Variant "Gadget B" has a default cost price of £15.00.
- On 03/01/2024, 5 units of stock are manually added via a Stock Adjustment.
- These units are now in the system at the cost price of £15.00, matching the default cost price at time of the Stock Adjustment.
Example 3: Stock Take
- Warehouse "North" has 10 units of "Gadget C" with varying cost prices.
- During a stock take, it is discovered that 2 units are damaged and removed from the system.
- The system deducts the 2 oldest units first, adjusting the average cost price accordingly.
FAQs
Can I have units of stock with multiple cost prices for the same item?
Yes, IXO Commerce allows you to manage multiple units of the same item with different cost prices and dates of receipt. This helps in accurate cost tracking and inventory management.
Will units of stock be linked to Purchase Orders?
Yes, if a unit of stock was ordered and received as part of a Purchase Order, the Purchase Order Id will be stored alongside the cost price and date or receipt.
What happens if stock units have different dates of receipt?
IXO Commerce allows you to track the date each unit of stock was received, which helps in identifying the age of your stock and managing stock rotation effectively.