sku

Thanks for adding me - first post, lets hit the ground running Here is what I am working with. 1.. Barcode / SKU scanner. 2 .. Excel Master Data List (all on one tab/sheet) Here is what I am able to do now. Take the scanner, scan a barcode on a product, excel finds that item and highlights the...

Hey Guys, I'm creating a very large budget for 2022 and using the 2021 budget as a starting point for an IT group. I want to create unique SKU's for the existing budgeting items so we can easily manage to the new budget next year and to track spend YoY. I have created 2 digit category's based...

Hi! I have a pricing file where i have various SKU's which are in the type ABC-XXX, AD-XXX & GE-XXX (could also be more but using these as examples). Each SKU has a price. I have another tab where i have listed what the % discount should be depending on the SKU type but don't know how to get...

Hi All, I am trying to understand the best combination of formulas to calculate the sell through of products with different expiration dates. All products with the closest expiration date (column c) to todays date (cell E1) by SKU (column a) should be depleted first inline with the weekly...

I have a sheet with headers SKU, Name and Stock. I would like to create an userform with 3 textboxes and 3 search buttons below the textboxes to perform a search whatever i enter into each box and place the found results into a listbox for easy viewing. I can write a macro to do a search on...

Hi all, I am attempting to automate my sales info per product order. I am using two workbooks. One workbook is static, pulling info from a marketplace website via APIs. The other workbook is created for each product order. It contains product manifest and product sales sheets. I...

Hello All, I need help on getting SKU value of duplicate/same items sourcing from different Suppliers with best price in the column F. Col # Title Column A Supplier Name Column B SKU Column C Model # Column D Count of Model# Column E Price After...

I have two sheets, I would like to find and match both sku's on both sheets, if the sku from sheet1 matches the sku from sheet2, i want to extract a column from sheet 2. Sheet1: <tbody> SKU QOH 1008 0 1011 0 1013 0 2135 0 </tbody> Sheet2: <tbody> SKU QOH 1008 4 1011 6 1013...

<colgroup><col><col><col span="3"><col><col><col></colgroup><tbody> Maximum Length 20 Product Information- User Input Generated SKU Code & Product Explanation Product Category Product Name Attribute1 Attribute2 Attribute3 Product Explanation Generated SKU Code Modified SKU Code SAS...

I want to match "Order IDs" and add the "sku items" for a total kit count. Thoughts? Thanks R. Turner

Hello, I'm a novice Excel user, but know basic formulas, but this need is stumping me. Need to find a formula to automate 100's of product image names based on the product SKU. I have a SKU number, imagename.jpg in 2 columns and need to have that list of individual SKUs in a new column with...

Hi. I have a sheet where I am working out product sales. In Sheet1 Column A I have all my SKUs. Each week when I product a report I want to store the current sales into Sheet2 so I can look back over time. The problem is, as we add new products, the list of SKUs in Sheet1 will grow. So I...

Cells in "SKU" column are the pasted value of cells in "SKU Formula" (concatenate) column. How do I get the "SKU" column (pasted value) to automatically update when a change is made to data in cells shown in SKU formula? <tbody> Collection Prefix Shape Size Supplier Color Code SKU Formula...

I need to produce a SKU GAP Fill report and would like to get some help. We have thousands of accounts and 53 SKU's and I need to find out from the sales reports from distributors which accounts are missing key SKU's. Any help would be appreciated.

Hello all Thanks again for this great forum. It is such a great learning curve. I am wondering if somebody could help me with a query. The BI dept at work send me on a weekly basis a report of SKU IDs and total qtys, but with the SKU description added to the SKU ID by a hypen. Some SKU IDs...

Hi there, I have a sales sheet that I use VLOOKUP for to return an item value for SKU which met my needs until now. The problem that I have is that the current VLOOKUP formula that I have at present will only work out the value of one item as it only references the SKU and performs the VLOOKUP...

Hello all. Thank you again for this great forum and the opportunity to learn from the many questions and answers. I have a question, which I hope will make sense. I have been given a reporting task on a daily transaction log where, for example, in Column A of the spreadsheet I will have many...

Hi, I have quantity and i want convert as per SKU size.i m using below formula but not getting proper result. Please help on this. <colgroup><col span="2"><col><col></colgroup><tbody> Qnty SKU Formula Reqd Value 100 120 =INT(A2/B2)&"."&A2-B2*INT(A2/B2) 0.100 245 120...

Hi, I have the below macro and just got a new work comp. New comp is unable to run my macro now. I think it might be a Windows 10 issue? I'm also running Office 365. Can anyone please help? I essentially need to have a macro look up a number in column E, find the corresponding jpg in a...

Good Morning, I need help getting an excel formula working. This is the formula I'm using: =IFERROR(AVERAGEIFS('Master SKU Tracker'!$E$2:$E$3922,'Master SKU Tracker'!$B$2:$B$3922,Scorecard!$B5,'Master SKU Tracker'!$C$2:$C$3922,Scorecard!$L$1),"") This formula is working perfectly for the...