Import Vendor Pricing

Back Top Prev Next Print

First, via the Jim2 Configuration Manager, right click on the server and select Configure. Click on B2BIn then click Enable to the right.

 

importvend4

 

You will need to restart the Jes instance on completion.

 

On the ribbon, go to eBusiness, then select the Import Vendor Stock icon.

 

importvendor

 

Locate the file and select it. Jim2 can import both .csv and Excel files. The following screen will appear:

 

importvend

 

Tick First Row is heading to allow for correct mapping. Select the correct columns in the Source Column fields. If you are only updating certain fields, ensure the Vendor Stock Code field is selected in the Source Column, then select any others you require.

 

importvend1

 

If you will use these mapped fields for future imports, you can enter a name for the mapping and click Save. Next time you import, you can select the mapping file you saved and it will pre-populate the Source Columns.

 

importvend2

 

The Skip Rows field allows you to enter a number to specify how many rows to skip, then use the next row as a column heading.

 

On the right hand side, select a Vendor cardcode.

 

importvend3

 

You can also tick one of the three Import schedule options.

Import stock and apply rules immediately will import new and update existing stock straight away.

Import stock immediately and apply rules as per schedule will do the same as above immediately, based on scheduled rules.

Import stock and apply rules as per schedule will import new and update existing stock based on scheduled rules.

 

Further information

Stock Security

Consignment Stock

Consignment Stock for Customers

Kitting v Packaging v Manufacturing

Kitting

Packaging

Promotional Pricing

Stock Adjustments

Stock Attributes

Stock Flow

Stock List

Create a Stock List

Stock Preview Pane

Stock Pricing

Order of Pricing

Stock Procurement

Stock Reports

Stock Transfers

Stocktake

Tabs in the Footer

Tabs in the Header

Warehouse Management

Add Stock

Add Service Stock

Add a Document to Stock

Add Groups to Stock

Add Images to Stock

Add Multiple Stock Records

Add Vendor Codes

Backfill Stock Sold in Advance

Buy and Sell in Different Measures

Buying your own stock

Change a Serial Number on a Stock Record

Change Stock GL Group

Create Similar

Deactivate a Stock Code

Deactivate Stock in Bulk

Donations of Stock

Export a Stock Report to Spreadsheet

Generate Backdated Stock on Hand Report

Handle Warranty Stock

Merge Stock Codes/Supersede

Move Stock from Depleting to Asset

Print Shelf Talkers

Print Stock Reports

Sell Stock in Advance

Set up Pricing

Stop Users From Giving Discounts

Track Serial Numbers

Unallocate Stock

Update Existing Stock Pricing

Update Existing Vendor Pricing

Update Lead Time on Vendor Tab

Update Stock Procurement Data

Update Stock Records

Use Stock Select

Use Your Own Inventory

View or Edit Stock

Write off Stock

Use Gift Card for Purchases