Ebay

P&L

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

• 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 Ebay

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

  • • $7.69 for Amazon FBA

    • $3.11 + Shipping for OAS

Channeladvisor

https://complete.channeladvisor.com/Inventory/AllProducts.mvc/List?apid=12009833&mode=AllItems

• Look for the SKU in Channeladvisor, if it is not in Channeladvisor yet, you can click "Create New"

• Setup the Child and Parent SKUs (If it is a variation)

• Fill in the following information:

• SKU = SKU

• Title = Product Title (150 characters max)

• Brand / Manufacturer = Wasserstein, Dartwood or Lectron

• Condition = New

• ASIN = ASIN

• UPC / EAN / MPN = Barcode

• Same as Child

• But also fill in the Variation Relationship section

Text Attributes

• Aside from the basic setup in Section 2, the following attributes need to be filled in too for Ebay

Format: Attribute name in Channeladvisor = details about the attribute

• Title = Product title that is shown in Ebay description area

• Description = Short product description shown below the Product title in the Ebay description area

• Bullet Point 1

• Bullet Point 2

• Bullet Point 3

• Bullet Point 4

• Bullet Point 5

• Color Map = color name

• Color Name = color name

• Size Map = pack size (1 Pack, 2 Pack, etc.)

• Size Name = pack size (1 Pack, 2 Pack, etc.)

• Ebay Buffer = buffer quantity to prevent overselling. Usually just leave it at "2"

• Ebay Handling = "1 Day" if the entire parent (all children) have stock in OAS, *Empty* if at least 1 child has no stock in OAS and only in FBA.

• Ebay Price = price

• Ebay Quantity = max quantity to send. We have monthly limits, so need to put a quantity here.

• EBAY_CATEGORY_ID

• EBAY_CATEGORY_ID_2

  • • You can put up to 2 categories for each Ebay listing.

    • To get the category number, you can copy it from existing listings we have that are similar products, or you can do the following:

      • • Go to https://www.ebay.com/ and search the main keyword for the product

        • From this main keyword, click the top 1-3 listings and click their category

        • Example: https://www.ebay.com/itm/Wasserstein-Ring-Solar-Panel-for-Spotlight-Cam-Stick-Up-Cam-Battery-1-Pack/264655577055

        • The 2 categories are: "Solar Panels & Kits" and "Security Cameras"

        • Click these 2 categories and you can get the "Category Number" from the URL

        • The category numbers are 4-5 digits contained in the URL. From the example, they are:

          • • Solar Panels & Kits = 41981

            • Security Cameras = 48638

            • Hence, the 2 categories are 41981 and 48638. You can put these into the 2 category attributes in Channeladvisor

• Ebay Title = Main product title in Ebay, shown in search results. Max 80 characters. Keywords in the titles need to be the keywords that customers search. They can be concatenations of different words, it does not have to be gramatically correct.

Image Attributes

• ITEMIMAGEURL1 = main product image, size must be 1500 x 1500 px (https://bulkresizephotos.com/en)

• ITEMIMAGEURL2, 3, 4, onwards = other product images in order. Ebay accepts up to 12 images.

For each Parent, you must also put an image into the Parent's ITEMIMAGEURL1 box. This is usually the best selling color for the Parent. If it is a pack size variation, put the 1-pack image into the Parent.

Example: Ring Solar Panel = White, Blink Solar Panel = Black, etc.

A+ Content Images

• Go to the Amazon listing for the same SKU to see the A+ content (if any)

• For example: https://www.amazon.com/dp/B07BNDNPKY?ref=myi_title_dp

• You can paste the image links into the "Images" section of the SKU in Channeladvisor. The boxes for the images are as following:

A+ Content Text

• Go back to the main text attributes in Channeladvisor.

• The A+ attributes correspond to the images (ie. Left 1 text is for Left 1 image, etc.)

• You need to format these as HTML. Ebay only recognizes HTML code in order to convert them to the A+ content style of Amazon. (ie: Line Break = <br>, Header = <h3>, etc.)

• The attributes are as follows:

• A+Description = text right below the A+ Header image

• A+Left1a = Header text for Left 1 image, it is formatted as Bold and Larger Font

• A+Left1b = description text for Left 1 image, it is formatted as normal text

  • • All a attributes are for the bold header text

    • All b attributes are for the normal text

    • These formatting follows the Amazon A+ Content style

• Check the Amazon video sheet if the SKU has a video: https://docs.google.com/spreadsheets/d/1E0hNNgdxSUZiPXr-18ZF3HX2bVbn18EMf8p03tKd7_I/edit#gid=236379586

• If there is a video, convert it to Ebay Embed Code: https://www.isdntek.com/tagbot/YouTubeConverter.htm

• Paste the embed code into the "Youtube Link" attribute in Channeladvisor.

• If more than 1 video, put a line break HTML code after each video to split them in separate rows.

• Before posting the listing on Ebay, double check all attributes in this template: https://complete.channeladvisor.com/Marketplaces/PostingTemplate.mvc?apid=12009833&siteId=576&siteInstanceId=1&postingTemplateId=467&categorySpecific=false&ReturnURL=https%3a%2f%2fcomplete.channeladvisor.com%2fmarketplaces%2fEBayFeedsGrid.mvc%3fapid%3d12009833

• If there are no more errors, you can add the "Ebay" label for non-automotive products and "Ebay Motors" label for automotive products. You can only add either of the two labels.

• Click save, and it should sync to Ebay within 1-2 hours.

• After the listing goes online on Ebay, we need to activate the Marketing.

• Ebay Listing page: https://k2b-bulk.ebay.com/ws/eBayISAPI.dll?ListingConsole&currentPage=LCActive

• Open the listing and click "Revise Listing"

• Scroll down to the bottom section and select the following:

• Check the promoted listing

• Select the "Suggested Ad Rate", if it is over 5%, put 5%.

• Select the campaign based on the compatibility brand

• Click "Update Listing"

To check which items are not yet activated for marketing, you can check this link: https://pls.ebay.com/plsweb/item