Target and Walmart

P&L

https://docs.google.com/spreadsheets/d/1hyl3X_FRkyFhtgK7QOHm3ivajl3_ckIGNcbkc3cpnBE/edit#gid=1220134011

• Input the SKU, if it is not already in the P&L, and copy down the formulas

• We want to make at least 25% margin on Target and Walmart

• Make sure that the fulfillment fees are according to the following:

  • • $3.11 + Shipping for OAS

    • We can only use OAS for Target and Walmart

The attributes and images from the Ebay setup carry over to the Target and Walmart setups. The only different attributes are the following:

• Title = must be 150 characters max (Used for Walmart only)

• Description = aside from the ebay description, must also contain all the text inside the images

• Target Category

  • • Default value is "home security accessories"

    • If it is not for this category, you can put the category here. The allowed values can be found in this link: https://go.channeladvisor.com/rs/485-FSD-368/images/Target%2BTemplateInformation.xlsx

      • • Under tab "Allowed Values Groups"

• Target Walmart Price = price for both Target and Walmart, they have same P&L

• Target Title = 150 characters max. We cannot have taglines or slogans at the end. Only product name, size, color etc.

• Target Sale Price = if you want to show a cheaper price or sale price, fill in the lower price in this attribute. It will compare the price to the "Target Walmart Price"

• Target Product Color = color category, allowed values are:

  • • Beige

    • Black

    • Blue

    • Brown

    • Clear

    • Gold

    • Gray

    • Green

    • Multicolored

    • Off-White

    • Orange

    • Pink

    • Purple

    • Red

    • Silver

    • White

    • Yellow

• Walmart Color Category = color category, allowed values are:

  • • Beige

    • Black

    • Blue

    • Bronze

    • Brown

    • Clear

    • Gold

    • Gray

    • Green

    • Multi-color

    • Off-White

    • Orange

    • Pink

    • Purple

    • Red

    • Silver

    • White

    • Yellow

• Batteries Required = "TRUE" if contains batteries or needs batteries, "FALSE" otherwise

• Battery Quantity = number of batteries

• Battery Size = battery size, allowed values are:

  • • AAA, AA, CR2, C, etc.

    • If unsure, you can use: "Non-Universal"

    • The size must be the same as the MSDS sheet, Target will check

• Battery Type = type of battery, values are: This must be same as the MSDS sheet

  • • Alkaline

    • Lead Acid

    • Lithium

    • Lithium Ion

    • Mercury

    • Nickel Cadmium

    • Nickel Metal Hydride

    • Silver Oxide

    • Zinc Air

    • Zinc Carbon

    • Zinc Chloride

• Target Template

  • • • https://complete.channeladvisor.com/TemplateEdit.mvc/Outbound?apid=12009833&ccid=15247

• Walmart Template

  • • • https://complete.channeladvisor.com/TemplateEdit.mvc/Outbound?apid=12009833&ccid=15504

• Verify that there are no errors, and all fields that have the orange arrow are filled in

• Once everything is complete, you can add the "Target +" and "Walmart" labels and click "Save"

• Listing will take 1-2 days to fully sync to Target

• For items that have batteries, we need to submit WERCs: https://secure.supplierwercs.com/v20/Orders/Cart?em=1

• You need to submit the UPC, SKU and MSDS Sheet

• For items without batteries, but have WERC errors, you can submit a ticket in the Target Portal (https://plus.target.com/) or email Sarah (Sarah.Loff@target.com). You can explain to them the product and why the WERCs tag should be removed

• Around 1-2 days after you submit, you can view the item status in the Target Portal (https://plus.target.com/), Walmart Portal (https://seller.walmart.com/items-and-inventory/manage-items) or through Channeladvisor (Sell > Target/Walmart > Listings).

• You can view all item status, errors, quantity, price etc. through these links.

• If you find any problems, you can edit the attributes or contact Target or Walmart support to help you resolve the issues.

• Once the items are online on the website, write at least 2 reviews.