Troubleshooting - How to create PriceLevelPerItem & PriceLevelFixedPercentage using QODBC

Problem Description:

How to create PriceLevelPerItem & PriceLevelFixedPercentage using QODBC.

Solution:

To create a new PriceLevel and PriceLevelPerItem item (at the same time) use below query:

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.

Note:  VB DEMO is to be used for testing of QODBC SQL queries only and is not a development tool.

Result in QuickBooks

The result looks like this in QuickBooks:

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'

To add another item to this PriceLevel we use below query:

INSERT INTO PriceLevelPerItem ("ListID","IsActive","PriceLevelPerItemItemRefListID", "PriceLevelPerItemCustomPrice") values ('80000007-1639572747', 1,'130000-933272656',150)

Result in QuickBooks

The result looks like this in QuickBooks:

To create a new PriceLevelFixedPercentage use below query:

Insert into PriceLevel (Name, PriceLevelFixedPercentage) values ('40.000', -40)

Result in QuickBooks

The result looks like this in QuickBooks: