SOLVED

Product inventory updates through CSV

%3CLINGO-SUB%20id%3D%22lingo-sub-1613321%22%20slang%3D%22en-US%22%3EProduct%20inventory%20updates%20through%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1613321%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there.%3C%2FP%3E%3CP%3EI%20am%20hoping%20to%20make%20the%20task%20of%20updating%20inventory%20easier%20and%20faster%20for%20my%20website.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20my%20product%20inventory%20list%20in%26nbsp%3B%20CSV%20file%20and%20I%20also%20have%20one%20from%20my%20supplier.%20The%20issue%20I%20have%20is%20that%20they%20have%201000%2B%20products%20and%20I%20am%20only%20selling%20about%2090%20of%20them.%20I%20have%20tried%20to%20Advanced%20Filter%20based%20on%20alphabetically%20sorted%20SKUs%20and%20the%20problem%20is%20that%20if%20I%20need%20for%20example%20AA110%20the%20filtering%20will%20also%20list%20AA1100%2C%20AA1101%2C%26nbsp%3BAA1102%2C%26nbsp%3BAA110X%20etc%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20my%20question%20is%2C%20is%20there%20a%20way%20to%20only%20filter%20for%20specific%20values%20or%20is%20there%20a%20better%20way%20to%20achieve%20what%20I%20am%20trying%20than%20Advance%20Filtering%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3CP%3EMal%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1613321%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1613425%22%20slang%3D%22en-US%22%3ERe%3A%20Product%20inventory%20updates%20through%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1613425%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F771823%22%20target%3D%22_blank%22%3E%40Beauty_Tables%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20your%20criteria%20type%20the%20following.%20It%20will%20force%20to%20only%20filter%20what%20is%20exactly%20equal%20to%20your%20criteria.%3C%2FP%3E%3CP%3E%3D%22%3DAA110%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1613464%22%20slang%3D%22en-US%22%3ERe%3A%20Product%20inventory%20updates%20through%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1613464%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20your%20message%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767933%22%20target%3D%22_blank%22%3E%40luthius%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20criteria%20field%20looks%20like%20this%3A%20%24G%241%3A%24G%2492%20and%20contains%2091%20values%20where%20should%20I%20type%20your%20suggestion%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1613473%22%20slang%3D%22en-US%22%3ERe%3A%20Product%20inventory%20updates%20through%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1613473%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F771823%22%20target%3D%22_blank%22%3E%40Beauty_Tables%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20final%20result%20of%20each%20of%20your%20product%2Fcriteria%20is%20%22%3D%22%20signal%20before%20the%20product%20name.%3C%2FP%3E%3CP%3EAs%20you%20are%20using%20advanced%20filter%20you%20need%20to%20identify%20the%20criteria%20column%2C%20meaning%20that%20your%20product%20code%20will%20start%20on%20G2%20instead%20of%20G1%20because%20on%20G1%20is%20the%20column%20name%20(Same%20as%20your%20main%20list).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suggest%20you%20instead%20type%20each%20value%2C%20you%20create%20an%20auxiliary%20column%20with%20the%20following%20formula%3C%2FP%3E%3CP%3E%3D%22%3D%22%26amp%3BG2%20and%20extend%20this%20to%20all%20your%20products%20column%20code.%20Then%20copy%20and%20paste%20special%20where%20you%20are%20keeping%20your%20criteria%20interval.%3C%2FP%3E%3CP%3EOr%20if%20you%20want%20to%20keep%20your%20product%20codes%20without%20the%20%22%3D%22%20signal%20you%20just%20put%20in%20a%20separate%20sheet%20and%20use%20a%20formula%20to%20get%20the%20%22%3D%22%20signal.%20Sheet2%20A2%3AA92.%3C%2FP%3E%3CP%3E%3D%22%3D%22%26amp%3BA2%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1613831%22%20slang%3D%22en-US%22%3ERe%3A%20Product%20inventory%20updates%20through%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1613831%22%20slang%3D%22en-US%22%3EThank%20you%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi there.

I am hoping to make the task of updating inventory easier and faster for my website. 

I have my product inventory list in  CSV file and I also have one from my supplier. The issue I have is that they have 1000+ products and I am only selling about 90 of them. I have tried to Advanced Filter based on alphabetically sorted SKUs and the problem is that if I need for example AA110 the filtering will also list AA1100, AA1101, AA1102, AA110X etc 

So my question is, is there a way to only filter for specific values or is there a better way to achieve what I am trying than Advance Filtering?

Thanks in advance,

Mal

4 Replies
Highlighted

@Beauty_Tables 

On your criteria type the following. It will force to only filter what is exactly equal to your criteria.

="=AA110"

Highlighted

Thank you for your message @Juliano-Petrukio 

 

My criteria field looks like this: $G$1:$G$92 and contains 91 values where should I type your suggestion?

Highlighted
Best Response confirmed by cuong (Microsoft)
Solution

@Beauty_Tables 

The final result of each of your product/criteria is "=" signal before the product name.

As you are using advanced filter you need to identify the criteria column, meaning that your product code will start on G2 instead of G1 because on G1 is the column name (Same as your main list).

 

I suggest you instead type each value, you create an auxiliary column with the following formula

="="&G2 and extend this to all your products column code. Then copy and paste special where you are keeping your criteria interval.

Or if you want to keep your product codes without the "=" signal you just put in a separate sheet and use a formula to get the "=" signal. Sheet2 A2:A92.

="="&A2

Highlighted
Thank you