Stock - Stock Import

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.


Dept, Cat, Grp and Type are not required unless you currently use. The order in the list is how the import routine works.


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
Need to be created prior to import with a description

6

Cat

Stock Grouping - Category
Need to be created prior to import with a description

6

Grp

Stock Grouping - Group
Need to be created prior to import with a description

6

Type

Stock Grouping - Type
Need to be created prior to import with a description

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
e.g. Case(12)

15

Def Sale CType

Case Type used
to sell e.g. Single

15

Comparitive Muliplier

Leave Blank

 

VAT Rates

R0 = 0
R1 = 23
R13 = 13
Let us know if you have VATRates

 

Barcode

Unique

 

Location

Bin Location
Bins would need to be created in Agility prior to import
Can be left blank if not using

 

PRF

Producers Recycling Fund or EMC
If not used Leave Blank

 

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
otherwise leave blank

 

Description Local

Different Lang used with Agility Touch
Leave Blank

50

Manufactured M/c/p

Used if company produces manufactured items
Leave Blank

 

Man Component

Used if company produces manufactured items
Leave Blank

 

Comp Ctype

Used if company produces manufactured items
Leave Blank

 

Comp Qty

Used if company produces manufactured items
Leave Blank

 

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
Leave blank

 

Import Cost Nominal

If you have import costs a nominal would need setting up.
Leave blank

 

Import Cost Method %/P

% or Price
Leave blank if you don’t know import cost

 

Import Cost Value

If Import cost method
was % then 10 = 10%
or Price 10 = 10
Leave blank

 

Commodity Code

Have suppliers outside of Europe

 

Commodity Country

Have suppliers outside of Europe

 

Recommended Qty to Buy









NOTE When importing codes and descriptions be carful and not have the following 6" x 6" GULLY GRIDS if you do when these are import the CSV file converts the description to this  "6"" x 6"" GULLY GRIDS"

How to import

Tools>Tools Menu>Import>Stock Records

  1. 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
  1. If not continuing select No
  2. Is this an Update File Yes or No
  1. This is to change information already held in agility e.g. description, category, group type etc.

  1. 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

  2. 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

    • Update Stock Records

      In Agility pro there is an option to import an update file to update existing stock records with new information, such as barcodes, case types, etc. Go to Tools-Tools Menu-Import-Stock Records When prompted Are you continuing with import from ...
    • Update Stock Records - Supplier

      Change a supplier from one currency to another and transfer stock Create a new supplier account with the currency recording what the new account is To update the stock records with the new supplier code follow the instructions: Go to ...
    • Update Stock Records - Suspend or Close

      INTRODUCTION In all businesses the stock file increases with stock that is no longer purchased or sold. Within Agility the function to update stock records can do this. Identify the codes that need to be suspended or closed. NOTE: Suspend basically ...
    • UPDATE Stock Prices

      UPDATE STOCK PRICES This allows you to update the price to a specific value The update can do both buy and sale prices SQL QUERY This can be used to extract data based on Category SELECT --The BuyPrice will need to be multiplied by the quantity of ...
    • Stock - Browse Stock

      INTRODUCTION In Agility browse stock gives the user the ability to search for stock in many different ways: Stock Code, Description, Preferred supplier and preferred supplier code, barcode, Department, Category, Group, Type, Job/Project and Analysis ...