Stock - Images in Agility Professional

Stock - Images in Agility Professional

INTRODUCTION

The Agility system supports images for stock codes. These images are held in a cloud location (Amazon S3 bucket).
Before images can be added please contact Agility as changes need to be made to your server.
Agility will then let you know when this is done.

For Agility Staff only:

FILE FORMATS

Images files of the following types/formats are supported:
- .jpg
Other image file formats ie. webp, gif, jpeg, jfif, are not currently supported. Images files with unsupported formats will not be displayed on Agility.

NAMING CONVENTION

How are images linked to stock codes?

1 main image and 4 secondary images are allowed, for 5 in total.
The main image must be named after the stock code in UPPERCASE. The naming convention for secondary images is STKCODE + optional _X.jpg, where X is a number 1 to 4.

For example, if the stockcode is ABC.
ABC.jpg           --VALID MAIN IMAGE
ABC_1.jpg  --VALID SECONDARY IMAGE
        ABC_2.jpg      --VALID SECONDARY IMAGE
ABC_3.jpg --VALID SECONDARY IMAGE
        ABC_4.jpg      --VALID SECONDARY IMAGE
ABC_B.jpg  --NOT VALID
        ABC_5.jpg      --INVALID SECONDARY IMAGE. ONLY 1 TO 4.


SPECIAL CHARACTERS

What Characters are not supported in Stock Codes?

For a stock code to work with images, it must not contain any of the following characters.
Alert
  < (less than)
  > (greater than)
  : (colon)
  " (double quote)
  / (forward slash)
  \ (backslash)
  | (vertical bar or pipe)
  ? (question mark)
  * (asterisk)
 

The underscore _ is allowed, but can cause the images to get mixed up.
You can run the following SQL query to get a list of all stock codes on your system with characters that are not supported.
This can be copied and pasted in the SQL Interactive Query window in Agility Pro:

  --[<]--
  select stkcode as [Code], '<' as [UnsupportedCharacter] from acocmp1.stkhead 
  where stkcode like '%<%'
	and discon <> 'X'
  union all
  --[>]--
  select stkcode, '>' from acocmp1.stkhead 
  where stkcode like '%>%'
	and discon <> 'X'
  union all
  --[:]--
  select stkcode, ':' from acocmp1.stkhead 
  where stkcode like '%:%'
	and discon <> 'X'
  union all
  --["]--
  select stkcode, '"' from acocmp1.stkhead 
  where stkcode like '%"%'
	and discon <> 'X'
  union all
  --[/]--
    select stkcode, '/' from acocmp1.stkhead 
  where stkcode like '%/%'
	and discon <> 'X'
  union all
  --[\]--
   select stkcode, '\' from acocmp1.stkhead 
  where stkcode like '%\%'
	and discon <> 'X'
  union all
  --[|]--
  select stkcode, '|' from acocmp1.stkhead 
  where stkcode like '%|%'
	and discon <> 'X'
  union all
  --[?]--
  select stkcode, '?' from acocmp1.stkhead 
  where stkcode like '%?%'
	and discon <> 'X'
  union all
  --[*]--
  select stkcode, '*' from acocmp1.stkhead 
  where stkcode like '%*%'
	and discon <> 'X'
  union all
  --[,]--
  select stkcode, ',' from acocmp1.stkhead 
  where stkcode like '%,%'
	and discon <> 'X'

ADDING IMAGES

Check the image location in Agility Pro System Parameters
Warning
The below will be done for you by Agility Customer Service , please do not change the images directory here as it will prevent images from uploading
Tools > Tools Menu > Companies > System Parameters > Additional System Parameters > Tab(Stock)
      - Show Pictures for stock Codes is ticked
      - The images directory, where the images will be stored prior to being uploaded to the cloud (must include the backslash [\] at the end)


Add Images via Cloudberry explorer or WinSCP

Info
More info to follow


Add Images via Agility Assistant

Using the Stock Information app, images can also be added:

Once logged into the app, search for a stock code or scan the barcode of an item:


Then press and hold on the blank grey image placeholders to take a photo (the top image is the main image, then the smaller images are the secondary images:


Take the photo:


Then tap the tick to confirm, or the X to take another:

The image then appears against the stock code:


Press and hold on one of the other place holders to add another image:


Once the job on your server has ran, the images will appear in Agility Pro then next day:



    • Related Articles

    • Images - Why are Images not changing?

      Introduction Images in Agility Professional can be overwritten. A new image will replace the old image, if the name and file type is correct. If you find images not being overwritten, follow the steps below to check everything is correct. For a full ...

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

    • Stock - Stock Item Maintenance

      INTRODUCTION There are different ways to create a stock codes in agility professional; create a code through POS, raising a Purchase Order, browse suppliers and select a button Stock Quick Set Up and by going to Stock\Ledger Maintenance\Stock Item ...

    • Stock - Cyclic Stock Take

      INTRODUCTION There are many ways to change stock levels in Agility Professional and one way is a cyclic stock take. This option is getting looked at to prevent the need to of a year end stock take at the end of the financial year. This options lets ...

    • Stock - Stock Item Maintenance - Price Tab

      INTRODUCTION Once a stock code has been created this can then be maintained by going to Stock\Ledger Maintenance\Stock Item Maintenance\Stock Items or by selecting the shortcut on the menu. From this screen a codes can also be created and there are ...