Online Inventory Management – Duplicate SKUs, Overselling, and the Importance of Integration

online inventory management part 2

More hours in the day. It’s the one thing every multi-channel merchant wants, and yet it’s impossible to attain. But what if you could free up significant amounts of time to focus on the responsibilities that really matter? This post resumes our series about online inventory management and expands the concept of having a single master SKU for every item in its base unit of measure. This way you can eliminate the time-consuming task of creating and managing duplicate SKUS and replace it with a value-added one like adding new products, sales channels, and suppliers.  

We have already discussed that by managing inventory at the ‘base unit of measure’ level, cost and inventory information can be controlled at the master SKU level, while listing content such as quantity, price, image, weight, and descriptions can be controlled at the individual listing level. We defined ‘base unit of measure’ and took a closer look at unit of measure conversion. Part 2 covers managing and publishing listing specific content as well as overselling and the importance of integration. 

For example, in the table below we’re selling O’Keefe’s ‘Working Hands’ Cream. There are 4 sales channel listings: 

  1. An ‘each’ listing on Amazon
  2. A 2-pack listing on Amazon
  3. A 4-pack listing on eBay
  4. A 6-pack listing on your website
Unit of
Measure
   Conversion    Item Base Unit of
Measure
Each 1 OKeefesWorkingHandseach 1 each
2-pack 2 OKeefesWorkingHands2-pack 2 eaches
4-pack 4 OKeefesWorkingHands4-pack 4 eaches
6-pack 6 OKeefesWorkingHands6-pack 6 eaches

 

  • All listings have unique quantities, prices, images, weights, and descriptions
  • The description of the ‘each’ listing says 1 unit and the description of the 2-pack listing says 2 units
  • The image and weight of the 4-pack listing is different from the image and weight of the 6-pack listing

You must control all this – listing specific content at the listing level, with cost and inventory information controlled at the master SKU level. This will prevent you from having to create duplicate SKUs just so you can manage different units of measure and the unique content (quantity, price, image, weight, and description) of each individual listing.

Why is creating duplicate SKUs a bad idea? It makes inventory management, purchasing control, and competitive repricing almost impossible because every SKU for every listing across every channel must first be manually combined! Not only is this task extremely tedious and time-consuming but it also prevents you from having true visibility to the velocity of the item (how many are selling in a given time period).

Publishing Allocations 

You must also have dynamic stock publishing and delisting. Let’s say you have 60 units of O’Keefe’s ‘Working Hands’ Cream in stock. You have 3 ‘each’ listings on Amazon, 1 ‘each’ listing on eBay, and 1 ‘each’ listing on your website. If you publish 100% of your inventory across all 5 sales channels you’ve just told the world you have 300 units in stock – and you could sell all 300 units if you’re not careful! You can’t allow this to happen. Based on your supplier’s fill rate, your fulfillment method options (pick-pack-ship, cross-dock, drop ship, etc.) and the variety of your inventory sourcing you must carefully configure the allocation you want published to each sales channel. 

For example, if your supplier has a 97% fill rate, you may want to publish only 95% of their stock to compensate for their fill rate and have a safety cushion. Also, if your supplier doesn’t provide an inventory file you could choose to set absolute values (i.e. always publish quantity of 3.) The last thing you want is to have your Amazon account suspended due to overselling. This is the key benefit to maintaining accurate inventory levels.

The Importance of Integration

Finally, whether you use an online inventory management system or an Excel spreadsheet, your solution must be integrated to purchasing and sales. As you buy and sell, your inventory levels must be kept up-to-date. When you order products and receive stock, your inventory counts should automatically go up. As you sell your products, your inventory counts should automatically go down. If your solution isn’t integrated to purchasing and sales then it’s dependent on you to do inventory adjustments.

If you receive inventory and don’t publish to your sales channels, you won’t sell anything because the sales channels think there are no products available. On the flip side, if your sales channels aren’t integrated to your inventory control, you’ll have to deduct inventory on a daily basis – or inventory levels will be artificially high and you’ll oversell.

See how critical it is to have a solution integrated to purchasing and sales?

If your solution offers sales integration but not integrated purchasing, you won’t get the input you need to grow and expand. Many new merchants use entry level solutions but it only gets them so far.


 

Bottom Line: Control listing specific content at the listing level and cost and inventory information at the master SKU level. This will prevent you from having to create and manage duplicate SKUs and allow you to spend more time on the work that matters. To avoid overselling and suspension carefully configure the allocation you want published to each sales channel. Your online inventory management solution must be integrated to purchasing and sales. If it’s not, then it’s dependent on you to do inventory adjustments. 

 

 

Learn More


204 Comments

  1. Alvincal on December 17, 2018 at 12:27 am


  2. Alvincal on December 16, 2018 at 5:56 pm


  3. Alvincal on December 16, 2018 at 11:46 am


  4. Alvincal on December 16, 2018 at 5:32 am


  5. Alvincal on December 15, 2018 at 11:35 pm


  6. MichaelDab on December 15, 2018 at 10:29 pm


  7. MichaelDab on December 15, 2018 at 6:12 pm


  8. Alvincal on December 15, 2018 at 5:33 pm


  9. MichaelDab on December 15, 2018 at 2:06 pm


  10. Alvincal on December 15, 2018 at 11:33 am


  11. MichaelDab on December 15, 2018 at 9:54 am


  12. Alvincal on December 14, 2018 at 7:12 pm


  13. Alvincal on December 14, 2018 at 1:25 pm


  14. Alvincal on December 14, 2018 at 7:21 am


  15. MichaelDab on December 14, 2018 at 4:18 am


  16. Alvincal on December 14, 2018 at 1:17 am


  17. MichaelDab on December 14, 2018 at 12:02 am


  18. MichaelDab on December 13, 2018 at 7:51 pm


  19. Alvincal on December 13, 2018 at 7:13 pm


  20. Charleswaf on December 13, 2018 at 6:51 pm


  21. Charleswaf on December 13, 2018 at 6:15 pm


  22. MichaelDab on December 13, 2018 at 3:52 pm


  23. Alvincal on December 13, 2018 at 1:15 pm


  24. MichaelDab on December 13, 2018 at 11:55 am


  25. Charleswaf on December 13, 2018 at 10:04 am


  26. Charleswaf on December 13, 2018 at 7:42 am


  27. Alvincal on December 13, 2018 at 6:48 am


  28. Aaronmoome on December 13, 2018 at 6:33 am


  29. Alvincal on December 13, 2018 at 12:50 am


  30. Alvincal on December 12, 2018 at 6:58 pm


  31. MichaelDab on December 12, 2018 at 5:07 pm


  32. MichaelKeyNc on December 12, 2018 at 5:01 pm


  33. Charleswaf on December 12, 2018 at 4:15 pm


  34. Charleswaf on December 12, 2018 at 3:17 pm


  35. Aaronmoome on December 12, 2018 at 3:03 pm


  36. MichaelDab on December 12, 2018 at 1:51 pm


  37. Charleswaf on December 12, 2018 at 1:31 pm


  38. Alvincal on December 12, 2018 at 12:55 pm


  39. MichaelKeyNc on December 12, 2018 at 12:27 pm


  40. Charleswaf on December 12, 2018 at 11:12 am


  41. Aaronmoome on December 12, 2018 at 10:53 am


  42. MichaelDab on December 12, 2018 at 10:31 am


  43. Charleswaf on December 12, 2018 at 10:10 am


  44. Charleswaf on December 12, 2018 at 8:49 am


  45. Charleswaf on December 12, 2018 at 7:38 am


  46. Alvincal on December 12, 2018 at 7:11 am


  47. MichaelDab on December 12, 2018 at 5:38 am


  48. MichaelKeyNc on December 12, 2018 at 5:34 am


  49. Aaronmoome on December 12, 2018 at 3:27 am


  50. Charleswaf on December 12, 2018 at 1:25 am


  51. MichaelDab on December 11, 2018 at 11:56 pm


  52. Alvincal on December 11, 2018 at 9:39 pm


  53. MichaelKeyNc on December 11, 2018 at 9:30 pm


  54. Aaronmoome on December 11, 2018 at 7:50 pm


  55. MichaelDab on December 11, 2018 at 6:28 pm


  56. Robertrog on December 11, 2018 at 6:19 pm


  57. Charleswaf on December 11, 2018 at 5:43 pm


  58. MichaelKeyNc on December 11, 2018 at 2:11 pm


  59. Alvincal on December 11, 2018 at 1:01 pm


  60. Aaronmoome on December 11, 2018 at 12:35 pm


  61. Charleswaf on December 11, 2018 at 11:29 am


  62. Charleswaf on December 11, 2018 at 10:06 am


  63. MichaelKeyNc on December 11, 2018 at 6:22 am


  64. Charleswaf on December 11, 2018 at 4:58 am

    [url=http://albendazole.in.net/]generic albendazole online[/url] [url=http://buysuhagra.us.org/]sildenafil citrate[/url] [url=http://propranolol.in.net/]propranolol[/url] [url=http://tadacipbest.us.com/]TADACIP[/url] [url=http://advairbest.us.com/]advair[/url] [url=http://hydrochlorothiazide.in.net/]hydrochlorothiazide[/url] [url=http://zithromaxgenericbuy.com/]antibiotic zithromax[/url] [url=http://ampicillin.us.org/]ampicillin 500mg[/url] [url=http://colchicine.in.net/]colchicine[/url] [url=http://synthroidgenericbuy.com/]synthroid 137mg without prescription[/url]



  65. Aaronmoome on December 11, 2018 at 4:47 am


  66. Alvincal on December 11, 2018 at 3:31 am


  67. Charleswaf on December 11, 2018 at 3:10 am


  68. Charleswaf on December 11, 2018 at 2:06 am


  69. MichaelKeyNc on December 10, 2018 at 10:39 pm


  70. Aaronmoome on December 10, 2018 at 9:19 pm


  71. Charleswaf on December 10, 2018 at 7:12 pm


  72. Charleswaf on December 10, 2018 at 6:34 pm


  73. Alvincal on December 10, 2018 at 6:30 pm


  74. MichaelKeyNc on December 10, 2018 at 3:25 pm


  75. Aaronmoome on December 10, 2018 at 2:07 pm


  76. Charleswaf on December 10, 2018 at 11:31 am


  77. Charleswaf on December 10, 2018 at 11:05 am


  78. MichaelKeyNc on December 10, 2018 at 7:59 am


  79. Aaronmoome on December 10, 2018 at 6:23 am


  80. Charleswaf on December 10, 2018 at 3:30 am


  81. Stewarthelay on December 10, 2018 at 3:18 am


  82. Charleswaf on December 10, 2018 at 3:08 am


  83. MichaelKeyNc on December 10, 2018 at 12:24 am


  84. Alvincal on December 9, 2018 at 11:39 pm


  85. Charleswaf on December 9, 2018 at 11:30 pm


  86. Aaronmoome on December 9, 2018 at 11:05 pm


  87. Charleswaf on December 9, 2018 at 7:59 pm


  88. Charleswaf on December 9, 2018 at 7:34 pm


  89. MichaelKeyNc on December 9, 2018 at 5:07 pm


  90. Charleswaf on December 9, 2018 at 4:32 pm


  91. Aaronmoome on December 9, 2018 at 3:58 pm


  92. Charleswaf on December 9, 2018 at 12:23 pm


  93. Charleswaf on December 9, 2018 at 12:05 pm


  94. Alvincal on December 9, 2018 at 12:04 pm


  95. MichaelKeyNc on December 9, 2018 at 9:59 am


  96. Charleswaf on December 9, 2018 at 9:13 am


  97. Aaronmoome on December 9, 2018 at 8:36 am


  98. Charleswaf on December 9, 2018 at 4:20 am


  99. Charleswaf on December 9, 2018 at 3:59 am


  100. MichaelKeyNc on December 9, 2018 at 2:11 am


  101. Charleswaf on December 9, 2018 at 1:46 am


  102. Alvincal on December 9, 2018 at 1:42 am


  103. Aaronmoome on December 9, 2018 at 1:03 am


  104. Charleswaf on December 8, 2018 at 8:34 pm


  105. Charleswaf on December 8, 2018 at 8:31 pm


  106. MichaelKeyNc on December 8, 2018 at 7:05 pm


  107. Charleswaf on December 8, 2018 at 6:30 pm


  108. Aaronmoome on December 8, 2018 at 5:52 pm


  109. MichaelDab on December 8, 2018 at 5:49 pm


  110. Alvincal on December 8, 2018 at 4:54 pm


  111. Charleswaf on December 8, 2018 at 1:10 pm


  112. Charleswaf on December 8, 2018 at 1:06 pm


  113. Stewarthelay on December 8, 2018 at 12:11 pm


  114. MichaelKeyNc on December 8, 2018 at 11:46 am


  115. MichaelDab on December 8, 2018 at 11:45 am


  116. Charleswaf on December 8, 2018 at 11:12 am


  117. Aaronmoome on December 8, 2018 at 10:48 am


  118. LarryAlove on December 8, 2018 at 9:52 am


  119. Alvincal on December 8, 2018 at 8:35 am


  120. MichaelDab on December 8, 2018 at 5:30 am


  121. Charleswaf on December 8, 2018 at 5:04 am


  122. Charleswaf on December 8, 2018 at 4:47 am


  123. MichaelKeyNc on December 8, 2018 at 3:44 am


  124. Charleswaf on December 8, 2018 at 3:16 am


  125. Aaronmoome on December 8, 2018 at 2:58 am


  126. Alvincal on December 8, 2018 at 12:20 am


  127. MichaelDab on December 7, 2018 at 11:39 pm


  128. Charleswaf on December 7, 2018 at 9:24 pm


  129. Charleswaf on December 7, 2018 at 8:59 pm


  130. MichaelKeyNc on December 7, 2018 at 8:19 pm


  131. Charleswaf on December 7, 2018 at 8:01 pm


  132. Aaronmoome on December 7, 2018 at 7:48 pm


  133. MichaelDab on December 7, 2018 at 6:09 pm


  134. Robertrog on December 7, 2018 at 6:05 pm



  135. Alvincal on December 7, 2018 at 3:59 pm


  136. Charleswaf on December 7, 2018 at 1:39 pm


  137. Charleswaf on December 7, 2018 at 1:00 pm


  138. MichaelDab on December 7, 2018 at 12:47 pm


  139. Robertrog on December 7, 2018 at 12:45 pm


  140. LarryAlove on December 7, 2018 at 12:45 pm


  141. Charleswaf on December 7, 2018 at 12:34 pm


  142. Aaronmoome on December 7, 2018 at 12:21 pm


  143. Charleswaf on December 7, 2018 at 5:29 am

    [url=http://buypropecia.us.com/]buy propecia[/url]



  144. Charleswaf on December 7, 2018 at 3:28 am


  145. Aaronmoome on December 6, 2018 at 5:25 pm


  146. KennethTum on December 6, 2018 at 12:38 pm


  147. Brettonelm on December 6, 2018 at 8:47 am


  148. descargar facebook on December 6, 2018 at 5:24 am

    I’m impressed, I have to admit. Rarely do I come across a blog that’s
    both equally educative and amusing, and let me tell you, you’ve hit the nail on the head.
    The problem is an issue that not enough folks
    are speaking intelligently about. Now i’m very happy that I found this in my search
    for something concerning this.



  149. DouglasPlaib on December 5, 2018 at 6:11 pm


  150. Charleswaf on December 5, 2018 at 8:23 am


  151. Sling TV on December 5, 2018 at 3:33 am

    Hello everyone, it’s my first visit at this website, and paragraph is in fact fruitful in support of me, keep up posting these types of articles.



  152. KennethTum on December 4, 2018 at 9:24 pm


  153. DouglasPlaib on December 3, 2018 at 10:27 pm


  154. Charleswaf on December 3, 2018 at 3:00 pm


  155. Aaronmoome on December 3, 2018 at 9:04 am


  156. KennethTum on December 3, 2018 at 6:23 am


  157. DouglasPlaib on December 2, 2018 at 2:12 am


  158. Charleswaf on December 1, 2018 at 9:04 pm


  159. Aaronmoome on December 1, 2018 at 4:59 pm


  160. KennethTum on December 1, 2018 at 3:29 pm


  161. DouglasPlaib on November 30, 2018 at 5:53 am


  162. Charleswaf on November 30, 2018 at 3:50 am


  163. Aaronmoome on November 30, 2018 at 1:15 am


  164. KennethTum on November 30, 2018 at 12:39 am


  165. Brettonelm on November 28, 2018 at 9:16 am


  166. KennethTum on November 28, 2018 at 8:57 am


  167. Aaronmoome on November 28, 2018 at 8:57 am


  168. DouglasPlaib on November 28, 2018 at 8:57 am


  169. Charleswaf on November 28, 2018 at 8:56 am


  170. Aaronmoome on November 28, 2018 at 7:26 am


  171. Charleswaf on November 28, 2018 at 12:16 am


  172. DouglasPlaib on November 28, 2018 at 12:10 am


  173. MichaelKeyNc on November 27, 2018 at 8:36 pm


  174. KennethTum on November 27, 2018 at 4:25 pm


  175. Aaronmoome on November 27, 2018 at 3:51 pm


  176. DouglasPlaib on November 26, 2018 at 1:50 am


  177. Charleswaf on November 26, 2018 at 1:50 am


  178. MichaelKeyNc on November 26, 2018 at 1:50 am


  179. Aaronmoome on November 25, 2018 at 11:39 pm


  180. KennethTum on November 25, 2018 at 11:39 pm


  181. Brettonelm on November 24, 2018 at 1:05 pm


  182. Charleswaf on November 24, 2018 at 12:55 pm


  183. KennethTum on November 24, 2018 at 12:52 pm


  184. DouglasPlaib on November 24, 2018 at 12:52 pm


  185. MichaelKeyNc on November 24, 2018 at 12:47 pm


  186. descargar facebook on November 22, 2018 at 1:10 pm

    Hello there! I know this is kinda off topic
    but I was wondering which blog platform are you using for this
    site? I’m getting tired of WordPress because I’ve had problems with hackers
    and I’m looking at alternatives for another platform.
    I would be great if you could point me in the direction of a good platform.



  187. descargar facebook on November 21, 2018 at 9:05 am

    Definitely believe that which you said. Your favorite reason seemed to be on the
    web the easiest thing to be aware of. I say to you, I certainly get
    irked while people consider worries that they plainly don’t know about.

    You managed to hit the nail upon the top as well
    as defined out the whole thing without having side effect , people can take a signal.
    Will likely be back to get more. Thanks



  188. What Equipment is Needed for Sling TV on November 20, 2018 at 12:08 pm

    Good day! I know this is kinda off topic but I was wondering which blog platform are you using for this
    site? I’m getting sick and tired of WordPress
    because I’ve had issues with hackers and I’m looking at alternatives for another
    platform. I would be great if you could point
    me in the direction of a good platform.



  189. What Equipment is Needed for Sling TV on November 19, 2018 at 10:12 am

    Hi there friends, how is everything, and what you desire to say concerning this
    post, in my view its genuinely amazing designed for me.



  190. What Equipment is Needed for Sling TV on November 18, 2018 at 7:11 pm

    This design is spectacular! You certainly know how to keep a reader
    entertained. Between your wit and your videos, I was almost moved to start
    my own blog (well, almost…HaHa!) Wonderful job.
    I really loved what you had to say, and more than that,
    how you presented it. Too cool!



  191. What Equipment is Needed for Sling TV on November 18, 2018 at 6:36 pm

    There’s definately a lot to learn about this topic.
    I love all the points you made.



  192. What Equipment is Needed for Sling TV on November 18, 2018 at 6:08 pm

    Hello there, just became alert to your blog through Google, and found that
    it is truly informative. I am going to watch out for brussels.
    I will be grateful if you continue this in future.

    Lots of people will be benefited from your writing. Cheers!



  193. What Equipment is Needed for Sling TV on November 17, 2018 at 12:32 pm

    If some one desires expert view concerning blogging after that i
    advise him/her to pay a visit this website, Keep up
    the nice job.



  194. sling tv coupons and promo codes for november 2018 on November 17, 2018 at 10:03 am

    Sling tv coupons and promo codes for november 2018
    When someone writes an article he/she retains the plan of a user
    in his/her brain that how a user can understand it. So that’s why this paragraph is amazing.
    Thanks! Sling tv coupons and promo codes for november 2018



  195. What Equipment is Needed for Sling TV on November 16, 2018 at 12:46 pm

    WOW just what I was looking for. Came here by searching for
    What Equipment is Needed for Sling TV



  196. Sling TV on November 15, 2018 at 6:21 am

    I think that what you published was very logical. However, what about this?
    suppose you composed a catchier title? I ain’t suggesting your content is not solid,
    but suppose you added something that grabbed people’s attention? I mean Easy,
    proven tips for worry-free online inventory management is
    kinda boring. You should peek at Yahoo’s home
    page and note how they write article headlines
    to get people to open the links. You might add a related
    video or a pic or two to grab people excited about everything’ve got to say.
    Just my opinion, it would bring your blog a little livelier.



  197. What Equipment is Needed for Sling TV on November 14, 2018 at 2:16 am

    I every time spent my half an hour to read this weblog’s content
    everyday along with a mug of coffee.



  198. What Equipment is Needed for Sling TV on November 13, 2018 at 9:35 pm

    This is really interesting, You are a very skilled blogger.

    I’ve joined your feed and look forward to
    seeking more of your fantastic post. Also, I’ve shared your web site in my social networks!



  199. What Equipment is Needed for Sling TV on November 12, 2018 at 7:17 pm

    I must thank you for the efforts you’ve put in penning this site.
    I am hoping to view the same high-grade content from you in the future
    as well. In truth, your creative writing abilities has inspired me to get my own,
    personal site now 😉



  200. What Equipment is Needed for Sling TV on November 12, 2018 at 12:06 pm

    This site definitely has all the info I wanted about this subject and didn’t know who
    to ask.



  201. What Equipment is Needed for Sling TV on November 10, 2018 at 5:27 pm

    Thank you, I’ve just been searching for information approximately this subject for
    a long time and yours is the greatest I’ve
    came upon so far. However, what in regards to the conclusion?
    Are you positive about the source?



  202. Sling TV on November 10, 2018 at 11:49 am

    This info is worth everyone’s attention. Where can I find out more?



  203. Sling TV on November 10, 2018 at 8:57 am

    Hi to all, how is everything, I think every one is getting
    more from this web site, and your views are nice designed for new viewers.



  204. What Equipment is Needed for Sling TV on November 9, 2018 at 7:04 pm

    I love it whenever people get together and share views.
    Great site, continue the good work!



Leave a Comment