Adding more price level on a inserting inventory
Greg Teresi asked 6 years ago
I’m inserting inventory into sql. We have different prices for quantity’s and and different customers.
So when I insert a item I can only insert one price. Is there a way to insert different prices with quantity breaks for the same item?
We do this manually.
So when I insert a item I can only insert one price. Is there a way to insert different prices with quantity breaks for the same item?
We do this manually.
Greg,
What is your destination? Is this a custom SQL table or part of a product such as GP? If it is GP, are you using eConnect to import items or going directly to the tables?
I’m importing the items from a excel spreadsheet thru SmartConnect into a stock GP map for inventory items. Thinking about it should I just add to the spreadsheet a copy of the item with another line changing the to quantity and price?
I got it I just add all the prices and quantities to the spreadsheet.
Thank you