Skip to main content
A
arkvalleyinfo
January 7, 2019
Question

When selling SKU's at both wholesale and retail, how do you list products into QB? And how to import CSV? I'd like to track at a product level - showing both biz sides?

  • January 7, 2019
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

Rustler
Rustler
January 7, 2019

QB has one item as inventory, you stock it.  How you sell it, retail or wholesale has nothing to do with stocking inventory

QBO has classes and locations, you can use those transaction tags to report on the tag.  
classes tag each item
location tags the whole transaction
for reporting

Typically you set the most sales price (retail or wholesale) on the item screen, and adjust the sales price as needed.

 

importing an excel sheet for transactions requires a third party add on, like transaction pro importer.  https://apps.intuit.com/app/apps/home

C
Cathy9887
May 2, 2019

Actually, it has a whole lot to do with whether its sold as wholesale or retail.  Let's say I want to track my inventory of cups.  I have 40 cups in stock.  If a retailer needs 8 cups for a client, they get a wholesale price.  But if a consumer wants to buy 2, they are charged a retail price.   But the inventory comes from the same shelves.  

 

So what you're saying is, I have to assume whomever is entering the invoice will know to do all the extra work to edit the pricing for the wholesale buyer??  That's a lot of extra work, and will slow down the process considerably.  No one wants to stand around while the seller fiddles with their computer to get the right pricing entered... that just looks incompetent.  

    MaryLandT
    MaryLandT
    May 2, 2019

    Hi there, @Cathy9887,

     

    Thanks for the complete details.

     

    Right now, price leveling is unavailable in QuickBooks Online. You'll have to manually edit the amount every time you invoice customers with different quantities.

     

    I've added this article to help you manage your inventories:

    Should you need additional information about your products and services in QuickBooks, don't hesitate to comment below. I'll be around whenever you need help.

    Terms & ConditionsAccessibility statement