cancel
Showing results for 
Search instead for 
Did you mean: 
jesterswink
Level 1

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?

 
12 Comments 12
Rustler
Level 15

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?

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

Cathy9887
Level 1

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?

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
Moderator

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?

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.

Malcolm Ziman
Level 10

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?


@MaryLandT wrote:

Hi there, @Cathy9887,

 

 

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.

.


Whoever programmed this robot needs to fix the program.  Tell it to consider the "Price Rules" feature.  It's true that quantity is not the determinant, but it's absolutely relevant that the customer is a wholesale Customer Type

cwhitman
Level 1

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?

Is it true that price leveling is still unavailable in QB online? 

RCV
QuickBooks Team
QuickBooks Team

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?

Thanks for dropping by in the Community, cwhitman.

 

At this time, the Price Leveling feature is unavailable in QuickBooks Online (QBO). You'll have to manually edit the amount every time you invoice customers with different quantities. If you need to control the price of your products and services like offering them discounts or charge different rates by item, just set price rules in QBO. I've added these articles to help you manage your inventories: 

 

If this is something our engineers need to look into, you can submit product suggestions by following these steps:

  1. Click the Gear icon at the top. 
  2. Choose Feedback.
  3. Enter your comments or product suggestions.
  4. Then select Next to submit feedback.

 

Your valuable feedback goes to our Product Development team to help improve your experience in QuickBooks Online (QBO). You can track feature requests through the QuickBooks Online Feature Requests website. Additionally, you can keep an eye on our QuickBooks Blog to stay up-to-date with the latest news.

 

You can always post again if you have questions about prices of your products and services.. I'll also address other QBO concerns you might have. Have a great day ahead. 

SmokinBandit
Level 2

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?

Tracking Wholesale vs Retail is a huge issue that I am struggling with.  I have to pay the sales taxes on the retail.  Manually subtracting all of my wholesale amounts from my total sales to pay the taxes is stupid, that's exactly what a computer should do.  I am pretty sure that QB can handle it and I am simply ignorant of how to implement.  If anyone knows the solution please chime in.

 

Here is my example in case it helps;

I make and sell BBQ sauce.  I sell Wholesale to grocery stores and I sell retail at farmers markets.  I enter invoices for sales and I have pricing levels set up for the different clients ( I use 

QB for Mfg) which is fine, but when I run a report at months end to pay sales tax all sales are posting to my retail sales account and none to my wholesale account.

 

I know I can set up the same Item twice in inventory as either retail or wholesale but that creates a huge issue when I transfer items from one item to the other.  (Basically when I do that it destroys my cost basis and makes COG unrecognizable.) Surely there is a way to post a sale as either retail or wholesale.

Charies_M
Moderator

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?

I appreciate the details you've shared about your concern, SmokinBandit.

 

Were unable to add different prices for a single item in QBO. While this preference is unavailable, you can either create another inventory item or use Price Rules.

 

To create a new item, follow the steps below:

  1. Click the Gear icon then select Products and Services.

  2. Hit the New button.

  3. Select a product/service type.
  4. Complete the product information and click Save and close.

To turn on your price rules:

  1. Tap the Gear icon and choose Account and Settings.

  2. Click the Sales menu.

  3. Tap the Pencil icon next to Products and services.
  4. Mark the Turn on price rules Beta box.
  5. Hit Save then Done.

I've attached here some articles to guide you with the process:

Here's an article for available reports that will help you see the product cost, the product on hand, and more: Use reports to see your sales and inventory status.

 

To give more information about managing inventory in QuickBooks Online, check out this article: Inventory management.

 

I'll be right here if you have further questions while working with inventory or any QuickBooks queries. Keep safe and have a good one.

SmokinBandit
Level 2

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?

Hi,

1.  What do you mean by "Price Leveling"? (Not sure what your trying to convey)

 

Changing Prices is trivial,  What is helpful is posting to either sales:retail or sales:wholesale. 

 

If not able to post directly to the appropriate sales account, how do you tag the transactions so they can be sorted easily?

 

Thanks!

Ethel_A
QuickBooks Team

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?

Hello there, @SmokinBandit. Let me add some information about price rules and tagging your transactions.

 

Pricing rules allow you to manage the cost of your goods and services. You can give discounts or charge varying rates depending on what you're selling. You can even limit them to specific consumers for a set period.

 

You can check this article to know more about pricing rules: Set price rules in QuickBooks Online.

 

Another option is to add a tag to your transactions. This way, you can track transactions however you'd like.

 

You can tag invoices, costs, and bills. To understand how specific parts of your business are doing, group tags together and run reports. They have no bearing on your books. Instead, they're a mechanism for your team to keep track of the information that's most important to you.

 

Here's how:

 

  1. Enter the tag name you want to create in the Tags field.
  2. Then choose + Add.
  3. To apply the tag to one of your groups, select it.

 

Refer to this article for more information about adding tags to your transactions: Tag transactions in QuickBooks Online.

 

I'm also adding these articles to learn more on how to use tags and groups to get better insights from QBO:

 

QuickBooks Online (QBO) has a variety of reports that you can run and customize. One of them is the Transaction List by Tag Group or the Profit and Loss by Tag Group.

 

After you've done customizing the report, you may also memorize it so that you can use the selections you've chosen in the future.

 

You can leave a comment below if you need additional assistance adding tags to your transactions. I'm always around to help.​​​​​​​

oceanbeachesglass
Level 5

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?


@SmokinBandit 

 

It sounds like you've considered this, but I think I'd set up two separate Products, one for your farmers market, and one for your grocery store sales.  Each could contain not only their specific price and cost, but also their specific Class or Location.  You can set them up so that the Inventory Asset, Sales, and COGS amounts all go into the same accounts - so they'd appear as one in your P&L, for instance, but could easily be separated with the Class/Location feature.

 

I sell both Retail and Wholesale, but from the same inventory in the same location - for which the above would be more difficult.  But I also have a POS that automatically handles price levels, so it's not an issue.  I just export my sales data from there into QBO. I don't have to worry about sales tax, either - but I think that would make it all the more advantageous to use two unique Products.  Just my two cents

oceanbeachesglass
Level 5

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?

Ethel, I've actually found Class/Location to be more useful than Tags for things I seriously want to track.  There seem to be more complete or useful Reports for Class than for Tags.  Plus, if you import data, the apps (at least the one I use, Saasant), doesn't include Tags for sales data import.

Need to get in touch?

Contact us