ecommerce

Hi experts, for reporting on e-commerce data I am preparing daily, weekly and monthly reports. The data sits in different databases (Oracle, Google Analytics and numerous third partner platforms). The KPIs needed are: order count, revenue, cost, clicks, impressions. Is there a way to automate...

Hello, I have a two dropdown based cells (C4 and C23) that have some values. Based on the selected dropdown condition, I need to hide/ unhide certain rows in another sheet (written macros for it). I'm using the following code, but only one works at a time. Could you please help as I'm stuck...

Hi, I have 2 sheets i.e Mandatory list example and Products. In Mandatory list example sheet there are categories wise mandatory fields need to be check in products sheet. I want whatever products don't have any mandatory field, need to be marked and whatever products have missing mandatory...

So I have some data exported from an ecommerce store. Tabe delimited file. I've created two delimiters, ^ and ##: ^ is before each order number. This indicates notes are over, or new order number ## indicates notes begin. If there is nothing after this across the row (say, 5 rows over) then...

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...

Hi all, I need to be able to write a Macro to somehow convert product spreadsheets given to me by a client into new spreadsheets properly formatted to import into a web eCommerce platform, Magento. I'm linking the sample of what the new format should be and, if you provide a simple code...