As a JuniperMarket brand, optimizing your product data increases the likelihood buyers will find you on JuniperMarket. The buyer experience is also improved because clearly presenting product details instills buyer confidence and increases the likelihood of conversion. 

Make it a habit to optimize or update your product data. This can be done by quickly exporting it from WebManager and then reviewing the following product data headers.

How do I quickly export & update my product data?

method 1: editing products via our product editor

1. Login to WebManager. Use your same login as JuniperMarket Seller Admin
2. In the vertical bar on the left side of the page, click the Products > Products Quick Edit
3. A spreadsheet like window will appear displaying all of your products.
4. In the first column “IsDeleted”, click the filter button and then the radio button for is false. This will only showcase products that are displaying on JuniperMarket.
5. Left click into a cell to edit the value. Then enter the appropriate value.
6. Click out of the cell or hit the Enter key.
7. Continue to populate other values for other products or click the red button to Save Changes.
8. Once your changes have saved, in the vertical bar on the left side of the page scroll down and click “Push Data Live”.
9. A pop up will appear confirming you want to push data live. Click Yes, Push My Data Live
10. The pop will then disappear once your data has been pushed live to JuniperMarket

method 2: editing products via our product data template (excel)

1. Login to WebManager. Use your same login as JuniperMarket Seller Admin
2. Export data from WebManager by going to Manage Data > Export Data> click the first blue button “Export Products”
3. A spreadsheet file will download as an XLSX. Open this in your favorite spreadsheet editor like Microsoft Excel.
4. Adjust or add any values to each particular header. For each header fully defined see here
5. Do not delete ItemID or isDeleted columns! 
6. Save your spreadsheet.
7. Let’s jump back into WebManager to upload this spreadsheet.
8. In the vertical bar on the left side of the page, click the “Manage Data” icon
9. In the expanded list of options under “Manage Data,” choose “Upload Data Sheets”
10. Under the drop-down titled “Choose what type of data you want to import,” choose Products
11. Click “Drop files here to upload” in order to find and select your spreadsheet. Files can be selected via Drag and Drop or browsed from a location on your computer.
12. Once you have selected the spreadsheet we worked on above, click “Open”
13. The spreadsheet will be uploaded and you will be asked to preview your data.
14. After previewing and checking the spreadsheet, click “My Data Looks Good”
15. In the vertical bar on the left side of the page notice and click “Push Data Live”. If it does not appear, scroll down the vertical bar to the bottom to see “Push Data Live”
16. A pop up will appear confirming you want to push data live. Click Yes, Push My Data Live
17. The pop will then disappear once your data has been pushed live to JuniperMarket 

What product data headers should I review & optimize? 

• ItemName: Product names should be clear and intuitive. Buyers frequently search for products using common terms like “chair” or “candle.” Product names should say exactly what the product is and any unique characteristics that set it apart. Ensure all titles succinctly capture what the product is, and avoid including promo/discount info or Item/SKU numbers in the title field as this will hurt relevance
• Description: Provide rich and detailed descriptions to explain and differentiate your product. Writing one or more descriptive sentences about your products is not only valuable to search results, it helps buyers feel confident enough to ultimately to buy, merchandise and sell it to their customers.
• Dimensions: Dimensions help buyers under the exact size of your product.
• OrderMinimumQuantity: If this is not populated, it defaults to 1. Set this appropriately so your order minimums are always met on the first add to cart & the orders does not have to be rejected / modified for not meeting your order minimum.
• OrderMultipleQuantity: Selling products in cases or packs? Set this appropriately so products are added to the cart in the appropriate increments.
• OnHandQuantity: This is required and if left blank will result in the product showing out of stock.
• Category: Assign multiple levels of JuniperMarket categories to your products. Buyer searches often include category terms, and category filters are critical tools to help buyers narrow down to the specific items they need or want. Without categories, your products will appear in less results and will not be included in category filters.
• BasePrice: Required. This is your wholesale price, ensure this is accurate & updated.
• PriceLevel1: Recommended. This can be set as your MSRP / retail price to  communicate to buyers the suggested retail price.
• PriceLevel 2 - PriceLevel20: Have different price levels for different customers? Take advantage of our 20 different price levels.
• Weight: Recommended. If you are using our Ship with Juniper or Ship with a Preferred Carrier option, having weight data gives your buyer an accurate estimate of shipping costs on checkout versus the shipping price being TBD.
• UDF1 - UDF5 & udf6 - udf20: UDF or user defined fields can be used for the product template & attribute mapping allowing you to display specifications on your product detail pages. Buyers can allow filter using style, color and materials.
• AdditionalPhotos: Buyers love to see additional product imagery. If your images are not named after the ItemID, utilize this field to tie additional product images to ItemIDs.
• AvailabilityDate: Populate the date products would be available. For example, if a product is not available until March 2024, you could populate 03/01/2024. If blank, this means the product is always available. JuniperMarket will soon have specific filters for availability date that buyers take advantage of. This field can only be updated in WebManager. 
• PhotoName: Any product without a photo will not appear. Use the PhotoName column as a reference to what you should name a product image / photo.
• isDeleted: Required. Ensure this is set to FALSE so products appear on JuniperMarket. If set to TRUE products will not appear on JuniperMarket.