Stock - Stock Import
Stock Import
Introduction
In Agility there are features that enable the importing of new stock codes, updating current stock codes and changing prices.
Here is a list of ALL items which can be imported but not ALL are required. Items highlighted are not required unless you use these functions.
Import Field | Description of Field | Field Length |
Stock Code | Must be unique | 25 |
Des1 | Stock Description | 50 |
Des2 | Leave Blank | 6 |
Dept | Stock Grouping - Accounting | 6 |
Cat | Stock Grouping - Category | 6 |
Grp | Stock Grouping - Group | 6 |
Type | Stock Grouping - Type | 6 |
Supplier | Supplier Code | 12 |
SuppCode | Supplier Stock Code - Code used by your supplier | 40 |
Base units | Leave Blank |
|
Def Buy Ctype | Case Type used to buy stock | 15 |
Def Sale CType | Case Type used | 15 |
Comparitive Muliplier | Leave Blank |
|
VAT Rates | R0 = 0 |
|
Barcode | Unique |
|
Location | Bin Location |
|
PRF | Producers Recycling Fund or EMC |
|
Matrix X | If not Fashion Leave Blank |
|
Matrix X Value | If not Fashion Leave Blank |
|
Matrix Y | If not Fashion Leave Blank |
|
Matrix Y Value | If not Fashion Leave Blank |
|
Matrix Z | If not Fashion Leave Blank |
|
Matrix Z Value | If not Fashion Leave Blank |
|
Season | If not Fashion Leave Blank |
|
Buy Price | Buy price by Default CaseType |
|
Sale Price inc Vat |
|
|
Sale Price exc VAT |
|
|
Stk Qty | If importing stock qty |
|
Description Local | Different Lang used with Agility Touch | 50 |
Manufactured M/c/p | Used if company produces manufactured items |
|
Man Component | Used if company produces manufactured items |
|
Comp Ctype | Used if company produces manufactured items |
|
Comp Qty | Used if company produces manufactured items |
|
Batched Tracked Y/N | If you have batched tracked items Seed etc |
|
No Discount Y/N | Prevents Code being discounted |
|
Min Margins | If you want a code to make a minimum margin |
|
Weight | Used on delivery |
|
Import Cost Nominal | If you have import costs a nominal would need setting up. |
|
Import Cost Method %/P | % or Price |
|
Import Cost Value | If Import cost method |
|
Commodity Code | Have suppliers outside of Europe |
|
Commodity Country | Have suppliers outside of Europe |
|
Recommended Qty to Buy | ||
How to import
Tools>Tools Menu>Import>Stock Records
- Are you continuing with import from previous data load
This question is in case these has been an import and there were some errors that needed resolving.
By selecting yes the previous file will populate the grid to import again
- If not continuing select No
- Is this an Update File Yes or No
- This is to change information already held in agility e.g. description, category, group type etc.
- The form opens for the fields that are on the CSV file to be added to the right column
These MUST match exactly
On the form in the top left is the word FILE from here the format that has been added to the right column can be saved so that there is no need to repeat the action
To save a format Select FILE>Save>Enter a name SalePrice, BuyPrice, EComm etc
To open select File>Open and select format required
If CSV has column headers select ignore
NOTE the saved file does remember this so check before importing - A new form opens showing how many records are being imported
Select the IMPORT button to import all records
If import fails a grid will appear with all items that need editing
Scroll to the right to see the error message E.G. Duplicate barcode double click on the row and remove barcode
Once done select the import button again
Related Articles
Stock - Special Promotions
INTRODUCTION There are different promotions that can happen in Agility Professional from: BOGOF or Buy One Get One Free Buy One, Get One with different discounts, 25%, 50% etc Buy One, Get One at a specific price Buy One, Get a specific item with ...Agility Pro 2025 Release Notes
Agility Pro 2025 -Images can now be view from the POS. A Picture Button has been added, clicking this will open a Window showing the associated Image for that Stockcode (if an image has bene added) -Emailing from Agility Pro has been enhanced and ...Comparative Labels
Setting Up Comparative Pricing on Shelf Edge Labels Introduction When printing shelf edge labels, there is the option to display a comparative price on the label (also referred to as "price per"). This feature allows customers to see a price based on ...Sale - Sales Orders
INTRODUCTION Sales Orders work directly with the delivery system and items can only be sold/despatched if there is a stock quantity. Create a Sales Order Navigate to Sales - Sales Orders and the screen that opens has the sale look and feel as ...