There is a text file with 5 prices in it and the approriate name for each item.

How do I update these prices into the PriceLevelPerItem File?

Is there a way to send the system minimum data on the INSERT statement and it will build some of the data.

ListID(PriceLevel), Name(PriceLevel), PriceLevelPerItemCustomPrice(PriceLevelPerItem).

How do I create the ListID(PriceLevelPerItem)?  What is the PriceLevelPerItemRefListID(PriceLevelPerItem)?  What are the field names in PriceLevelPerItem that contains the ListId(from PriceLevel), ListID(from ItemInventory) to help in this function.

Can you specifically give me an example of an INSERT statement for PriceLevelPerItem where only the minimum date is passed?

Thanks

Ok, you can import PriceLevelPerItem lists, but the only restiction is that the items must already exist in QuickBooks. See: How do I add a Inventory Item using QODBC? for more on adding the item to QuickBooks before creating the PriceLevelPerItem special price.

To create a new PriceLevel and PriceLevelPerItem item (at the same time) you do:

INSERT INTO PriceLevelPerItem ("Name","IsActive","PriceLevelPerItemItemRefListID",
"PriceLevelPerItemCustomPrice")
values ('Door Bell Special', 1,'550000-1197760985',20)

where the Name 'Door Bell Special' is the new PriceLevel.

To add another item to the 'Door Bell Special' price level, you need to first determine the ListID for the PriceLevel you want to add the item too. This can be found by doing:

SELECT ListID, Name, PriceLevelType from PriceLevel where Name='Door Bell Special'

From this we can see that the PriceLevel ListID is: 60000-1197761756.

To add another item to this PriceLevel we do:

INSERT INTO PriceLevelPerItem ("ListID","IsActive","PriceLevelPerItemItemRefListID",
"PriceLevelPerItemCustomPrice")
values ('60000-1197761756', 1,'560000-1197762079',1)

After these two inserts the PriceLevelPerItem table shows the following items for: 'Door Bell Special' 

select ListID, Name, IsActive, PriceLevelPerItemItemRefListID,
PriceLevelPerItemItemRefFullName, PriceLevelPerItemCustomPrice
from PriceLevelPerItem where Name='Door Bell Special'

To update a PriceLevelPerItem we do this:

UPDATE PriceLevelPeritem SET PriceLevelPerItemCustomPrice = 43.21, PriceLevelPerItemItemRefListID = 'F0000-933272656'  WHERE ListID = '30000-1197755980' AND PriceLevelPerItemItemRefListID = 'F0000-933272656'

Note: The PriceLevel and PriceLevelPerItem tables are currently available to USA users of QuickBooks 2005 or later only.

I have not purchased your software as of yet.  What I need is a tool that will allow me to import a list of items with three different price levels into the PriceLevelPerItem table.  All the items will be on file and the PriceLevel tabel will have the three levels in it.  I can format the data as needed.  What tools would I need to buy to accomplish this?

I am trying to use Microsoft Access to read thru a CSV file and write records into the PriceLevel table.  I am trying to read the ItemInventory file to get the ListID for the item with the FullName of '003/115'. I am using the following code:

Private Sub Command0_Click()
    Dim SQLArg As String
    SQLArg = "Select ListID, FullName from ItemInventory where FullName='003/115'"
    DoCmd.RunSQL SQLArg
End Sub

When I run it, I get the error "A RunSQL action needs an SQL argument consisting of an SQL statement.".  What am I needing in order to get my SQL statement to work?

Thank you,

WallyKJ

Hi

I am not able to find this table PriceLevel ...............

I am using qodbc 8.0 and quickbook sdk 07/08

Thanks