1. Home
  2. Point-Of-Sale Software
  3. Problem with quicksell import tool

Problem with quicksell import tool

I've managed to import a list of products into RMS using the Quicksell import tool. The description, lookup, barcode format, price, cost and supplier all work perfectly. Only problem I'm having is setting the 'Item tax' field. I've tried entering the code and description from the Item taxes list, but it always creates a new form of item tax.

I've also tried runnig a query on an item that has the same tax status as I'd like to set for my new products

Select TaxID from item where itemlookupcode = '001594'

This query resulted in the number 2 for the TaxID. Tried putting 2 in the csv, but this just created a new item tax called '2' Am I doing something wrong?

Cheers

Reply to
jetspeed
Loading thread data ...

If we make this simple, then lets assume all your products have the same tax rate.

What is the ID for the tax item. If you open the dbo.ItemTax table, the ID column would represent this number. Since you're using the import tool I'm going to assume you don't have another DB management program (I suggest Aqua Data Studio (free) from aquafold.com).

Anyway I guess just use the Administrator program. After launching the Store Operations Administrator, connect to the database (File->Connect); enter the DB password and click OK. From the menu select Query->New

***to list your tax items run this query***

SELECT * FROM [dbo].[ItemTax] GO

(make note of the value in the ID column)

**to set all of your products to the ID from the above query then run this***

UPDATE [dbo].[Item] SET [TaxID]=2 (or 1 or whatever the ID number is from the ItemTax table) GO

Reply to
manicsquirrel

Reply to
Steve

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.