amazon

Hi, I need to get data from Amazon and eBay and have it in my Excel Sales dashboard. I need to have it refreshed without additional files etc. Is it possible to connect there? Thank you for your suggestions. Maciek

Hi, I have the following data in excel and am looking for a way to split it out into seperate lines - I was thinking Power Query could be the answer but not sure on the steps I could take. It is a one off data clean so I am also up for doing it in Excel via formula but again not certain on the...

Hi Guys I'm hoping someone can help. I have a spread sheet with all my products which include the purchase price, shipping costs and fees etc. I have a column for the minimum sale price, and this needs to be the break even price after VAT @ 20%, amazon fees, packaging costs etc Here is an...

Hello, I've been using this site for awhile now and it's been very helpful. Thanks. In most cases, I could find what I need or at least find something close enough that I could modify it to work. I've tried the same approach this round, with no luck. My excel document has 2 sheets that I'm...

i'm trying to learn a few new reports at work. one of the things i need to do is based on a pivot table. i've been able to create the data just fine but i'd really like to make it look like the previous person who did this. i can't seem to find a way to see all the formats applied to a pivot...

Hi, I'm importing data from our credit card bills. I want to bring the data into our accounting system. We have an issue when the names are not always the same. IE Shell 1234 and Shell 4354. I would like it to load it to the name Shell. Or Amazon charge of Amazon, Amazon Direct or Amazon...

Hi everyone, I'm quite new to excel and have been trawling the internet and YouTube for answers but couldn't find what I was looking for exactly. So I have a transaction sheet from Amazon for accounting purposes. All I want to see is how much I had made per item. However, the way Amazon show...

Can someone help me format this expression correctly? If the state is NJ and the credit card is Amazon then No tax but if the state is NJ and the credit card is anything other than Amazon then tax. =IF(AND(oknshipstate="NJ",okncreditcard="Amazon"),"No Tax", if...

i sell on amazon and when i want to upload by catalog in bulk amazon provides this flat file. when i open it, it asks to either enable or disable macros. if i click either or once i wanna save that file i get this annoying message that says Microsoft Visual Basics does anyone know what to do here

Hi as an employee of an Amazon business, I want to make a listing on amazon. How can I calculate a markup of 10% in excel? - the markup is “on the cost of the item plus the fee amazon takes after the item being sold” which is a percentage of the listing/sale price? Is it possible to have an...

4 years ago with the help of these forums, we managed to get a formula for us which we've been using ever since in our profit calculation sheet for e-commerce. It was this thread here...

I have a spreadsheet that contains a list of Descriptions of User Names - obviously password protected itself. I have a range of names of "Descriptions" in the column A1 to A20. This range I have called "MyUserNames" and might contain "Amazon - Paul" or "Amazon - Liza". In the corresponding...

Hi, I have data on seven worksheets, examples below: <colgroup><col><col><col span="2"></colgroup><tbody> Worksheet 1 Name Contact number Quantity Company Richard 1234 10000 Amazon Mike 2345 5000 Amazon Michael 5678 3000 Amazon Nancy 4567 5000 Amazon Alpha 6789 8000 Amazon Bravo...

I don't have a lot of experience with VB Scripts or Macros so I hope you can help me. I have two separate workbooks that have different header columns on them. One is an Amazon workbook that has specific header columns in order to import products. The other is my distributor that I have to...

Hello guys! I currently have a database with company info that is organized by quarters I would need to summarize by year. The database is roughly organized like the table below, but with a lot more inputs per company and doing SUMIF manually will be an task with no end. I tried using index...

Hi, Does anyone have a macro or a template builder to reconcile Fulfilled by Amazon (FBA) inventory Thanks in advance Hiten

Hi, need to calculate prices for Amazon, I'm calculating: cost to acquire + 50% margin + 15% Amazon fee's, And both percentage should adjust accordingly. e.g. my cost to acquire is $50 the results should be $98.69, currently I'm using a website to do the calculations (...

Can someone point me in the right direction to make this work? GetLowestPricedOffersForASIN I have all the keys i need and i'm trying to to use XMLHTTP60 lib to open the address http://mws.amazonservices.com?&ASIN=B00COK3FD8... etc but its not working. Would anyone know what im doing wrong. I...

At present i use below mentioned vba for amazon offer data extraction. <code>Sub Macro1() ' ' Macro1 Macro ' ' With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://www.amazon.com/gp/offer-listing/B00N41UTWG/ref=olp_f_new?ie=UTF8&f_new=true" _ ...

Hello everyone, I have an Amazon store with 2000+ products but I need a Macro to extract data from Amazon URLs of my products, particularly the "Product Bullet Points/Features" section and "Product Description" section. Then the next I need is to download the 1000x1000 pixel or greater full...