Question

In: Operations Management

Excel Workbook for product research on amazon

Excel Workbook for product research on amazon

Solutions

Expert Solution

Below mentioned is the Label row for product research on Amazon in an Excel Workbook. Also, find an example below the structure

Product Type Seller SKU Brand Product ID Product ID Type Item Name (aka Title) Manufacturer Part Number Recommended Browse Nodes Colour Name Colour Map Size Included Components Enclosure Material size_map Batteries are Included Standard Price Quantity Update Delete Maximum Retail Price Main Image URL Manufacturer Description model Search Terms Bullet Point Bullet Point Bullet Point Bullet Point Bullet Point Occasion Pattern Product Features Product Features Product Features Product Features Product Features Style Number of Pieces Power Source Shape Warranty Description Safety Warning Legal Disclaimer Item Package Quantity Business Price Quantity Price Type Quantity Price 1 Quantity Lower Bound 1 Quantity Price 2 Quantity Lower Bound 2 Quantity Price 3 Quantity Lower Bound 3 Quantity Price 4 Quantity Lower Bound 4 Quantity Price 5 Quantity Lower Bound 5 Pricing Action
feed_product_type item_sku brand_name external_product_id external_product_id_type item_name part_number recommended_browse_nodes color_name color_map size_name included_components material_type size_map are_batteries_included standard_price quantity update_delete maximum_retail_price main_image_url manufacturer product_description model generic_keywords bullet_point1 bullet_point2 bullet_point3 bullet_point4 bullet_point5 occasion pattern_name special_features1 special_features2 special_features3 special_features4 special_features5 style_name number_of_pieces power_source_type item_shape warranty_description safety_warning legal_disclaimer_description item_package_quantity business_price quantity_price_type quantity_price1 quantity_lower_bound1 quantity_price2 quantity_lower_bound2 quantity_price3 quantity_lower_bound3 quantity_price4 quantity_lower_bound4 quantity_price5 quantity_lower_bound5 pricing_action

Example

Detailed descriptions of examples in row. sku title standard-product-id product-id-type product_type brand manufacturer mfr-part-number description bullet-point1 bullet-point2 bullet-point3 bullet-point4 bullet-point5 merchant-catalog-number msrp ingredients1 ingredients2 ingredients3 indications directions minimum-weight-recommendation maximum-weight-recommendation weight-recommendation-unit-of-measure flavor size color scent item-price currency quantity launch-date release-date restock-date leadtime-to-ship max-aggregate-ship-quantity sale-price sale-from-date sale-through-date search-terms1 search-terms2 search-terms3 search-terms4 search-terms5 item-type used-for1 used-for2 used-for3 used-for4 used-for5 subject-content1 subject-content2 subject-content3 subject-content4 subject-content5 target-audience1 target-audience2 target-audience3 other-item-attributes1 other-item-attributes2 other-item-attributes3 other-item-attributes4 other-item-attributes5 main-image-url swatch-image-url other-image-url1 other-image-url2 other-image-url3 other-image-url4 other-image-url5 other-image-url6 other-image-url7 other-image-url8 fulfillment-center-id parent-sku parentage relationship-type variation-theme coverage finish-type1 finish-type2 item-form material-type1 material-type2 material-type3 count number-of-items item-specialty1 item-specialty2 item-specialty3 item-specialty4 item-specialty5 target-gender power-source is-ac-adapter-included item-weight-unit-of-measure item-weight item-length-unit-of-measure item-length item-width item-height item-diameter item-diameter-unit-of-measure shipping-weight-unit-of-measure shipping-weight display-length display-length-unit-of-measure display-weight display-weight-unit-of-measure display-volume display-volume-unit-of-measure are-batteries-included are-batteries-required battery-type1 battery-type2 battery-type3 number-of-batteries1 number-of-batteries2 number-of-batteries3 lithium-battery-energy-content lithium-battery-packaging lithium-battery-voltage lithium-battery-weight number-of-lithium-ion-cells number-of-lithium-metal-cells warnings legal-disclaimer prop-65 cpsia-warning1 cpsia-warning2 cpsia-warning3 cpsia-warning4 cpsia-warning-description is-adult-product product-tax-code max-order-quantity is-gift-message-available is-giftwrap-available is-discontinued-by-manufacturer registered-parameter platinum-keywords1 platinum-keywords2 platinum-keywords3 platinum-keywords4 platinum-keywords5 update-delete
03AMZNTRUF01 Amazon Face Care Cleansing Pillows 079346140763 UPC HealthMisc Amazon Skincare Amazon.com AMZN-234890 A whole new way to reveal softer, smoother, healthier-looking skin. Moisturizing INTAMZN-38917 10.95 Citric Acid, Sodium Bicarbonate, Maltodextrin, Calcium Silicate, PEG-180, Guar Hydroxypropyltrimonium Chloride, Sodium C14-16 Olefin Sulfonate Dispose of pillow in trash receptacle (do not flush). For optimum freshness, keep vanity lid closed, and store unopened refill packs in a cool, dry place. 9.95 USD 120 2004-08-11 2004-05-01 2 8.95 2004-11-15 2004-11-30 facial pillows cleansing face facial-cleansing-pads normal-skin combination-skin unisex-adult men women hypoallergenic http://my-server.com/path/to/image.jpg No LB 1.50 IN 1.20 If product gets into eyes, rinse thoroughly with water. A_GEN_NOTAX true true

Related Solutions

The attached Excel workbook, BUSI1013 Bank Dataset.xlsx, contains the data collected from research study. Answer the...
The attached Excel workbook, BUSI1013 Bank Dataset.xlsx, contains the data collected from research study. Answer the following questions using this data set. (18 points) What would the population of interest be for this study? Which method of sampling was used in this study? How big is the sample size? How many variables are in the data set? Which of the variables are in nominal scale? Name the variable(s) measured in ratio scale. Name the variable(s) measured in interval scale. Which...
This chart isn't available in your version of Excel. Editing this shape or saving this workbook...
This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart. How i can solve this problem on excel ??
Discuss some of the ways that data can be entered into a new Excel workbook. Next...
Discuss some of the ways that data can be entered into a new Excel workbook. Next explain various ways to customize the appearance of your completed workbook to present the data more professionally.
Create a new workbook in Excel. Please include an input area and an answer area for...
Create a new workbook in Excel. Please include an input area and an answer area for each problem. You will have an answer for each bullet point. Formatting is up to you. Just make sure it is easy to tell where your answers are, and what equation you used in excel to get the answer. 5. Assume you have won the lottery and have the choice of (1) receiving $1,000,000 now or (2) receiving $120,000 each year for 20 years....
Create a new workbook in Excel. Please include an input area and an answer area for...
Create a new workbook in Excel. Please include an input area and an answer area for each problem. You will have an answer for each bullet point. Formatting is up to you. Just make sure it is easy to tell where your answers are, and what equation you used in excel to get the answer. 2. If a 6.5 percent annual return can be expected: • How much would a 20-year old person have to put into a retirement fund...
Create a new workbook in Excel. Please include an input area and an answer area for...
Create a new workbook in Excel. Please include an input area and an answer area for each problem. You will have an answer for each bullet point. Formatting is up to you. Just make sure it is easy to tell where your answers are, and what equation you used in excel to get the answer. Assume a farmer has a choice of purchasing either a subsurface drip irrigation (SDI) system or a low energy precision application (LEPA) center pivot. The...
Create a new workbook in Excel. Please include an input area and an answer area for...
Create a new workbook in Excel. Please include an input area and an answer area for each problem. You will have an answer for each bullet point. Formatting is up to you. Just make sure it is easy to tell where your answers are, and what equation you used in excel to get the answer. Given the baseline gross receipts (no water restriction scenario) of irrigated cotton production versus the conversion of irrigated acres to dryland scenario, calculate the net...
Part I We’ll use the “Debt and Taxes” tab in the Lab 5 Excel Workbook The...
Part I We’ll use the “Debt and Taxes” tab in the Lab 5 Excel Workbook The Economic Data Runs from 1946 (1st year post WW2) to 2016 Note: This issue is tremendously more complicated than the two variables presented here. This is only a partial look at the issue and there is ample room for debate as causes of the issues at hand. 1) Examining the Relationships               Create and copy in the following Charts                              1) Line Chart with...
Refer to the ‘Data Task A’ sheet in the accompanying Excel workbook. You have been provided...
Refer to the ‘Data Task A’ sheet in the accompanying Excel workbook. You have been provided the most recent Profit and Loss Statement for T&K Solutions that shows the bookkeeping service is losing money. Using the proforma in ‘Schedule 1’, re-calculate the 2017 profit for T&K Solutions without the bookkeeping service. Be careful to take into account all additional information provided in the ‘Data Task A’ worksheet. DATA FOR TASK A: 2017 Profit and Loss Statement for T&K Solutions: Taxation...
Sales Manager has an excel workbook listing properties for sale. If a property is sold, Select...
Sales Manager has an excel workbook listing properties for sale. If a property is sold, Select National Properties Group will finance the property loan for 30 years as 7.5% interest. If the monthly payment of a property is greater than $3000,000 the company will give the buyer a 1% discount on the selling price. Assignment: Calculated the column using the PMT Function to calculate the monthly payment for each of the properties. Then insert a calculated column using the IF...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT