|
Creating an Import File |
|
This tutorial will outline each the steps involved when creating an inventory import file. |
|
Click here to download the |
|
Instructions |
|
|
Columns & Functions |
Microsoft Excel (.xls) sample import file.| Inventory import field headers | Associated field in Product Details | Sample Values | Note |
| PRODUCT DETAILS | |||
| ProductDetailsID | Enter a numerical value here. | The Kyozou ID, which is used by Kyozou, to view your item. It is highly recommend you leave this blank and allow Kyozou to do it for you. | |
| ProductID | Product # | 10000, 10001, 10002, 10003, 10004, 10005 | This value is the identifying value within Kyozou for your inventory item. If a product ID is not assigned when uploading to Kyozou then it will beautomatically generated by the system. |
| AdID | Ad Number | 1,2,3,4,5,6,7,8,9 | The internal description identification number of a product within Kyozou. Allow Kyozou to generate this for you. |
| Manufacturer | Manufacturer | Apple | First Title Part Value for Product Classification Categories |
| Model | Model | M9245LL/A | Second Title Part Value for Product Classification Categories |
| UPCModelDesc | Classification SKU code | 731304015505 | The Classification SKU code for Kyozou to help catalogue your items within Kyozou for all your items. |
| SKU | SKU | Enter the desired SKU for the item | SKU is an identification, usually alphanumeric, of a particular product that allows it to be tracked for inventory purposes |
| ModelDescription | Model Description | IPod 40GB Portable Mp3 Player | Third Title Part Value for Product Classification Categories |
| Title | Product title | Apple iMac (MA876LL/A) (20, 2 GHz, 2 GB, 250 GB) Mac Desktop [Example] | Type in a well made title that uses all available keywords and characters to properly redirect buyers in searches to you. |
| SubTitle | Subtitle | Brand new in box, complete with all manuals and valid warranty [Example] | Add extra information you want buyers to see when they are browsing search results. |
| Quantity | Quantity | Enter a numerical value here. | Enter the quantity you have of the item. |
| QtyOnEBay | |||
| QtyOnAmazon | |||
| InfinityQuantity | Unlimited Supply | Check Box, Checked = True; Unchecked = False. | This will make your inventory item set as infinity quantity or not. |
| ProductCategoryNumber | Product Classifications | 1,2,3 | These are the Kyozou ID's to the product classification categories you set up in your control panel section 19, you can get the ID numbers from section 20 of the control panel |
| IsTemplate | Indicate Template | Check Box, Checked = True; Unchecked = False. | If this is marked true, then this item will be used as a template for other items; If marked false, then this item will not be used as a template for other items. |
| FolderName | Folder | Foldername1, Foldername2, Foldername3 | You are able to create custom folders to store your products in and help with organization. It will also assist you with auto listing/relisting profiles. |
| SeparateLabels | Separate Labels | Check Box, Checked = True; Unchecked = False | If you have items with more than one quantity and stored in separate locations you may elect to create separate labels to help Kyozou keep track of them. |
| LotSize | |||
| UPC | UPC | Enter the UPC for the item | located within the "catalogue Item Identification" section of Kyozou at the top of the Product Details |
| GTIN | GTIN | Enter the GTIN for the item | located within the "catalogue Item Identification" section of Kyozou at the top of the Product Details |
| MPN | MPN | Enter the MPN for the item | located within the "catalogue Item Identification" section of Kyozou at the top of the Product Details |
| Brand | Brand | Enter the brand name for item | located within the "catalogue Item Identification" section of Kyozou at the top of the Product Details |
| Load | Load/Sku number | Input Load/Sku location here | Enter the Load or Sku if applicable you got the item from. |
| Reference__Reference Name | Product References | Enter here values for your products' global references | Here is an example, using a product reference names 'SKU': The column header would be 'Reference__SKU' (without quotes). For 'Serial Number', the header will be 'Reference_Serial Number' (without quotes). |
| Classification__Classification Name | Product Classifications | Enter here values for your products' classifications | You must enter here only values that already exist in the classification's drop down menu, which can be edited in the control panel. |
| PRODUCT CUSTOMS INFORMATION | |||
| FCC | FCC | A Valid FCC number. (if applicable) | The Federal Communications Commission number associated with your item. |
| FDA | FDA | A Valid FDA number. (if applicable) | The U.S. Food and Drug Administration Number associated with your item. |
| HarmonizedTariffCode | Harmonized Tariff Code | A Valid 10 digit HTC Number. (if applicable) | The Harmonized Tariff Code associated with your item. |
| CountryOfOrigin | Country of Origin | Canada, United States, Australia, etc… | This is where the item was created/manufactured. |
| PRODUCT DESCRIPTION | |||
| Description | Product Description | This item is made from 100% recycled linen. It is 5x5 and bright red. | This is the global description of your item for all venues. Html may be used here. If left blank, no changes will be made to its value. To clear the value for the field, set it to '[delete value]'. |
| AdditionalDescription | Additional Product Description | There is a dent on the left side of the item, but works perfectly. | Additional Description Field allows you to give anymore information to your buyer you think he should know about your product. If left blank, no changes will be made to its value. To clear the value for the field, set it to '[delete value]'. |
| InternalNote | Internal Note (Will not be displayed online) | This item has a crack in the screen. | You may enter information to be displayed amongst your company internally, customer will never see this. You may set it in your control panel step 4 and prevent it from listing to ebay unless it is reviewed by another person. If left blank, no changes will be made to its value. To clear the value for the field, set it to '[delete value]'. |
| TemplatePictures | Product Images (Multiple images can be added in this section) | http://mypictures.com/12345.jpg, http://mypictures.com/12344.jpg | You may either use this option or templatepictures to add what pictures you wish to have with your item. |
| OtherPictures | Product Images (Multiple images can be added in this section) | http://mypictures.com/12345.jpg, http://mypictures.com/12344.jpg | You may either use this option or templatepictures to add what pictures you wish to have with your item. |
| RequiresAdditionalPicture | Requires Additional Picture(s) | Check Box, Checked = True; Unchecked = False. | If marked as True, then before item is listable it will require more pictures. If marked as False, then item will not require extra pictures and be listable once it meets all the requirements set in your control panel. |
| AvailableColors | Color | rd,gr,bl | The global value for the colors available for your item for non eBay listings |
| ThisProductColor | Color | bl | The global value for the color that your item is set to. |
| AvailablePartsManuals | Package Contents | Parts,Manuals | Type in all available parts/extras that should come with the item separated by comma. |
| IncludedPartsManuals | Package Contents checkboxes | Manuals | Type in what parts/extras that you have with your item separated by comma. |
| ECOMMERCE | |||
| EcommerceDescription | Use general description | If this field is populated, "use general description" will be unchecked. | You may use a custom description for your ecommerce that will override the one you have set for your item. |
| EcommerceCategoryID | Category | 136203 | These categories are created by you within the Control Panel, in step 18 "E-Commerce Store Categories" |
| EcommerceCategory2ID | Category 2 (optional) | 136205 | These categories are created by you within the Control Panel, in step 18 "E-Commerce Store Categories" |
| EcommercePrice | E-Commerce Price | Enter a numerical value here. | You may set a different price for your E-Commerce items here. |
| EcommercePriceCurrency | -= Select Currency =- | USD/ CAD/ EUR/ GBP/ JPY | Allows you to select from a list of currencies defined by you in you control panel. |
| EcommerceCategoryName | Category | Clothing (Men), Music Players, Women's High Heels | These categories are created by you within the Control Panel, in step 18 "E-Commerce Store Categories" |
| EcommerceCategoryName2 | Category 2 (optional) | Clothing (Men), Music Players, Women's High Heels | These categories are created by you within the Control Panel, in step 18 "E-Commerce Store Categories" |
| EcommerceKeywords | Seo Meta keywords | kyozou, auction, listing management, eBay provider | keywords can be defined as the specific terms used by person to search for something on the net. |
| EcommerceMetaDescription | Seo Meta Description | Brief description of the contents of your page. | Meta description tag is intended to be a brief and concise summary of your page's content. |
| DoNotListToEcom | Do not list to E-Commerce | Check Box, Checked = True; Unchecked = False. | If marked as true, then item will NOT be listed to e-commerce; if marked as false, then item will be listed to E-Commerce. |
| StoreCreditPercent | |||
| SEOTitle | Seo Title | kyozou, auction, listing management, eBay provider | SEO title is the header of the webpage. |
| SeoKeywords | Seo Meta keywords | kyozou, auction, listing management, eBay provider | keywords can be defined as the specific terms used by person to search for something on the net. |
| SeoDescription | Seo Meta Description | Brief description of the contents of your page. | Meta description tag is intended to be a brief and concise summary of your page's content. |
| SeProductUrl | Search-Engine Friendly Page URL | lot-of-2-elpida-2gb-2rx8-pc2-6400-ebe21ue8acwa-8g-e- memory-sticks | This is a URL that contains keywords relevant to the product. |
| HomePageFeatured | Feature Product on Home Page | Checkbox, checked = True Unchecked = False | To feature this product on your ecommerce site |
| CategoryFeatured | Feature Product on Category | Checkbox, checked = True Unchecked = False | To use this product as a category featured on your ecommerce site |
| PromotionalProduct | Feature Product as a Promotional Product | Checkbox, checked = True Unchecked = False | To show this listing as a promotional product |
| FirstDomesticCalculatedShippingServiceFreeOnEcom | Free Domestic Shipping on E-commerce (Not applicable with fixed rates) | Checkbox, checked = True Unchecked = False | If selected, calculated shipping on ecommerce will show up as Free on this product |
| PRIVATE ECOMMERCE | |||
| PrivateEcommerceDescription | Use general description | Check Box, Checked = True; Unchecked = False. | You may use a custom description for your private ecommerce that will override the one you have set for your item. |
| PrivateEcommerceCategoryID | Category | 136203 | These categories are created by you within the Control Panel, in step 24 "Private E-Commerce Store Categories" |
| PrivateEcommerceCategory2ID | Category 2 (optional) | 136205 | These categories are created by you within the Control Panel, in step 24 "Private E-Commerce Store Categories" |
| PrivateEcommercePrice | E-Commerce Price | Enter a numerical value here. | Enter your private e-commerce price |
| PrivateEcommercePriceCurrency | -= Select Currency =- | USD/ CAD/ EUR/ GBP/ JPY | select currency for the private e-commerce price. |
| PrivateEcommercePrice2 | Price for Level 2 | Enter a numerical value here. | Kyozou allows you to set your private e-commerce customers at different levels, level 2 is considered better than level 1. You can tell your items to sell to level 2 users at a better price then level 1. |
| PrivateEcommercePrice3 | Price for Level 3 | Enter a numerical value here. | Kyozou allows you to set your private e-commerce customers at different levels, level 3 is considered better than level 2. You can tell your items to sell to level 3 users at a better price then level 2. |
| PrivateEcommerceKeywords | SEO Meta Keywords | ||
| PrivateEcommerceMetaDescription | SEO Meta Description | ||
| DoNotListToPrivateEcom | Do not Use | Check Box, Checked = True; Unchecked = False. | If this is marked true, then it will NOT list to your private E- Commerce; If it is marked false, then it WILL be listed to your private E-Commerce. |
| KYOZOU AUCTIONS | |||
| KyozouCategory | Category | 136205 | Select the category for the product if Kyozou auctions is enabled. |
| KyozouPrice | Price | Enter numerical value here. | Select the price for kyozou, if Kyozou auctions enabled. |
| KyozouPriceCurrency | -= Select Currency =- | USD/ CAD/ EUR/ GBP/ JPY | select the currency for kyozou price, if Kyozou auctions enabled. |
| PRODUCT PRICING | |||
| RetailPrice | Retail Price | Enter the equivalent numerical price. | To help calculate your profit and loss reports, and to give you a better understanding of how you are doing in the online market. It is only shown to you and never the customer. |
| RetailPriceCurrency | -= Select Currency =- | USD/ CAD/ EUR/ GBP/ JPY | You may select the currency for the retail price. |
| CostPerUnit | Cost per Unit | Enter the equivalent numerical price. | To help calculate your profit and loss reports, and to give you a better understanding of how you are doing in the online market. It is only shown to you and never the customer. |
| CostPerUnitCurrency | -= Select Currency =- | USD/ CAD/ EUR/ GBP/ JPY | You may select the currency for the cost per unit. |
| MSRPPrice | MSRP Price | Enter the equivalent numerical price. | It is only shown to you and never the customer, but it is an internal record for you to use to keep track of the MSRP. |
| MSRPPriceCurrency | -= Select Currency =- | USD/ CAD/ EUR/ GBP/ JPY | You may select the currency for the manufacturers suggested retail price. |
| DisableAllDiscounts | Disable all Discounts | Check Box, Checked = True; Unchecked = False. | If marked True, then all discounts will be disabled; if marked false, then all discounts will be available to be used with the product |
| QUALITY ASSURANCE | |||
| DoNotListToEbay | Do not list to eBay | Check Box, Checked = True; Unchecked = False. | If this is marked true, then it will NOT list to eBay; If it is marked false, then it WILL be listed to eBay. |
| DoNotListToAmazon | Do not list to Amazon | Check Box, Checked = True; Unchecked = False. | If this is marked true, then it will NOT list to Amazon; If it is marked false, then it WILL be listed to Amazon. |
| RequiresApproval | Requires Approval | Check Box, Checked = True; Unchecked = False. | If this is marked true, then you will be required to view and save the item a second time before listing to eBay; If it is marked false, then it will be immediately available to list to eBay. |
| PRODUCT DIMENSIONS | |||
| DimensionL | L | Value in inches | Specify the length in inches for the item. |
| DimensionH | H | Value in inches | Specify the height in inches for the item. |
| DimensionW | W | Value in inches | Specify the width in inches for the item. |
| Weight | Weight (lbs) | Value in pounds | Please enter the numerical value for the weight of your item in either pounds of kilograms depending which unit of measurement you choose in your shipping and courier settings within your control panel, or the settings within your warehouse. |
| WeightLbs | Please enter the numerical value for the weight of your item in either pounds of kilograms depending which unit of measurement you choose in your shipping and courier settings within your control panel, or the settings within your warehouse. | ||
| WeightOz | Please enter the numerical value for the weight of your item in ounces depending which unit of measurement you choose in your shipping and courier settings within your control panel, or the settings within your warehouse. | ||
| PRODUCT SHIPPING DETAILS | |||
| PickupOnly | Pickup only | Check Box, Checked = True; Unchecked = False. | If this is marked as true, then this item WILL only be available for pickup; if this is marked as false then this item will be available for other shipping methods |
| PickupHandlingFeeProfileId | |||
| ShippingOnly | Shipping Only | Check Box, Checked = True; Unchecked = False. | If this is marked as true, then you WILL only offer shipping services for this item; if this is marked as false then you will allow your item to use other services like pick up. |
| HandlingFee | Pickup Handling Fee | Enter a numerical value here. | the pickup handling fee amount. |
| DisableCombinedShipping | Disable Combined Shipping | Check Box, Checked = True; Unchecked = False. | If marked true, then you will NOT allow multiple orders to have combined shipping; if marked false, then you WILL allow combined shipping of the products you sell. |
| ShippingHandlingCost | |||
| ShippingHandlingFeeProfileId | |||
| FixedShippingExpressValue_0 | Edit Rates | 10;2 | Here is where you will specify the rate of the Fixed Shipping service. Using the values of X;Y (separated by a semicolon). X = price and Y = additional item price. |
| FixedShippingExpressService_0 | Edit Rates | OtherStandardDomestic | Here is where you will specify the fixed shipping service. Usually by combining the name of the shipping service into one word |
| FixedShippingExpressRegions_0 | Edit Rates | Domestic, Mexico, Japan, Germany, Australia, United Kingdom, Canada, Asia, Europe, Americas | Here is where you will specify the regions that can choose this fixed shipping service. NOTE: if you wish to offer more than one fixed shipping service, you will duplicate these headers on your spreadsheet and change the '_0' to '_1' and '_2', etc |
| PRODUCT LOCATION ASSIGNMENT | |||
| PlaceID | Shelf ID for filtering by Search Column or Full location name | Unique Shelf Id Value from Warehouse Management. | This value identifies the physical location of the product within the warehouse you are importing too. |
| MULTI-LISTER | |||
| MultilisterSettings_eBay_1 MultilisterSettings_eBay_2 Etc. |
Adding an eBay account in Multi-Lister settings | yes,no | Simply put 'yes' as values for all cells, in order to enable the import for the Multi-Lister headers. |
| *any eBay field header*_1 *any eBay_field header*_2 Etc. |
All Multi-Lister for eBay headers | The same values for the regular eBay headers. | Example: the header eBay_ListingType changes the type of the listing in the product details. To set the listing_type for our first eBay Multi-Lister account (the order is set in the control panel), we need to use eBay_ListingType_1. For the second Multi-Lister profile, the header will be eBay_ListingType_2, and so on. |
| amazon_UseMultiLister | Use Amazon Settings when listing to Multi- Lister | True/False | If enabled, when listing to Multi-Lister, the item will also be listed to Amazon with settings configured in the product. |
| Shopping.com | |||
| ShoppingComCategoryNumber | Category | 13110101 | You can set your Shopping.com specific category for the item you wish to market with it. |
| ShoppingComPrice | Price | Enter in a numerical value | You may can input your products price for Shopping.com. |
| ShoppingComCurrency | -= Select Currency =- | USD/ CAD/ EUR/ GBP/ JPY | You may select the currency for your Shopping.com Price. |
| ShoppingComItemCondition | Condition | New, Very Good, Good, Etc… | You can set your item condition for Shopping.com. |
| ShoppingComMPR | Shopping.com MPN / UPC Number (Optional) | Enter the MPN/UPC of your item here. | You can optionally add your Manufacturer's Part Number or UPC number here of your item to help increase visibility on Shopping.com. |
| Shopzilla | |||
| ShopzillaCategoryNumber | Category | 16030900 | The Shopzilla category best fitting for your item. |
| ShopzillaPrice | Price | Enter in a numerical value | The price of your item so Shopzilla knows what to advertise it as. |
| ShopzillaCurrency | Currency | USD/ CAD/ EUR/ GBP/ JPY | You may select the currency for your Shopzilla Price. |
| ShopzillaItemCondition | Condition | New, Refurbished, Etc… | You may enter the condition of your item here for Shopzilla. |
| ShopzillaPromoText | Promo Text | Enter Text Here. | You can enter promotional text about your item here to help with exposure. |
| ShopzillaDescription | |||
| ShopzillaOther | Other (Optional Field) | Enter notes here about the item | You can enter here notes about the item that will be availble only to yourself. |
| GOOGLE SHOPPING | |||
| GoogleBaseDoNotList | Do not use | Check Box, Checked = True; Unchecked = False. | If marked true, then product will not be available for ecommerce, if marked false, then item will be available for ecommerce. |
| GoogleBaseCategoryNumber | Category ID# | 4,658,2461 | Enter a numerical number that corresponds a GoogleBase category or pick from from the list provided by clicking the button. |
| GoogleBasePrice | Price | Enter in a numerical value | Enter the price of your item for Google Base to advertise. |
| GoogleBaseCurrency | -= Select Currency =- | USD/ CAD/ EUR/ GBP/ JPY | Select the currency of the item to Google Base. |
| GoogleBaseItemCondition | Item Condition | New/Refurbished/Open Box/Used/OEM | Describe the condition of the item to Google Base. |
| GoogleBaseLabel | Label/Keywords | Enter keywords here | Enter keywords specific to your item here to help Google Base direct traffic to your item. |
| GoogleBasePaymentNotes | Payment Notes | Enter Notes | Enter Payment notes for Google Base. |
| GTIN | Global Trade Item Number (GTIN) | 00012345678905 | Enter your GTIN here. |
| Brand | Brand | Apple [EXAMPLE] | Enter your product's brand here. |
| MPN | Manufacturer Part Number (MPN) | HSC0424PP | Enter your MPN here. |
| PRICE GRABBER | |||
| PriceGrabberCategoryNumber | Category | 1694 | The Price Grabber Category best fitting to your item. |
| PriceGrabberPrice | Price | Enter in a numerical value | Enter your products price here for price grabber. |
| PriceGrabberPriceCurrency | -= Select Currency =- | USD/ CAD/ EUR/ GBP/ JPY | Select the form of currency you accept for your item. |
| PriceGrabberItemCondition | Condition | New/Used/Refurbished .. ETC. | Select the condition of your item for Price Grabber. |
| PriceGrabberManufacturer | Manufacturer (if not yet selected) | Sony | Input the manufacturer, if not yet selected, for your product here for Price Grabber. |
| PriceGrabberUPCISBN | UPC/ISBN (if not entered above) | 342342342342342 | Enter The UPC/ISBN if not done above for Price Grabber. |
| VARIATIONS | |||
| Variations | Add | Color:red|blue|green;Material:cotton|rope | The different variations you want to use for your item. Different variation values are separated by |, while different variations are separated with ; |
| VariationQuantities | Use Variation Related Quantity | Color:red|Material:cotton#342;Color:red| Material:rope#342;Color:blue|Material:cotton#234; Color:blue|Material:rope#243;Color:green|Material:cotton#23;Color:green|Material:rope#33 |
Enter quantity values for variations. |
| VariationPrices | Use Variation Related Prices | Material:cotton|Color:red#2;Material:cotton|Color:blue#23; Material:cotton|Color:green#3;Material:rope|Color:red#44 |
Enter your price differences for variations. |
| VariationPictures | Use Variation Related Pictures | Material:cotton|Color:red#http://pictures.com/12011850.jpg;Material:cotton| Color:blue#http://pictures.com/12011851.jpg;Material:cotton| Color:green#http://pictures.com/12011852.jpg;Material:rope| Color:red#http://pictures.com/12011853.jpg;Material:rope| Color:blue#http://pictures.com/12011855.jpg;Material:rope| Color:green#http://pictures.com/12011856.jpg | Enter an HTML url or internal location where the image is located. |
| SendVariationsToEBay | Send Variations to eBay | Check Box, Checked = True; Unchecked = False. | If marked as True, then your variations will be sent to eBay, if marked as False, then they will not. |
| Inventory Quantity | |||
| AvailableQTYincrease | QTY | Numeric Value | Using this header with a value will increase the products used with it by whatever value you input here. |
| AvailableQTYdecrease | QTY | Numeric Value | Using this header with a value will decrease the products used with it by whatever value you input here. |
| eBay Specific Options | |||
| eBay_DomesticShippingDiscountProfileID | Calculated eBay Shipping discount | ProfileID | The promotional eBay shipping discount name ID#, you want to use for international shipping. You can get these from your control panel step 11. go into your eBay account, and at the bottomw in the shipping details section these values are located there. |
| eBay_InternationalShippingDiscountProfileID | Calculated eBay Shipping discount | ProfileID | The promotional eBay shipping discount name ID#, you want to use for international shipping. You can get these from your control panel step 11. go into your eBay account, and at the bottomw in the shipping details section these values are located there. |
| eBay_DomesticPromotionalShippingDiscount | Use promotional eBay shipping discount - Domestic | Check Box, Checked = True; Unchecked = False. | If marked true, then you will use promotional eBay shipping discount for domestic shipping; if marked false, then you will not use the promotional eBay shipping discount for domestic shipping. |
| eBay_InternationalPromotionalShippingDiscount | Use promotional eBay shipping discount - International | Check Box, Checked = True; Unchecked = False. | if marked true, then you will use promotional eBay shipping discount for international shipping; if marked false, then you will not use promotional eBay shipping discount for international shipping. |
| eBay_FirstDomesticServiceFree | Free Domestic Shipping | Check Box, Checked = True; Unchecked = False. | When checked, free domestic shipping will be enabled, and worldwide shipping will be calculated |
| eBay_ListingType | Listing Type | Auction/BinOnly etc… | You can specify which eBay listing type you wish to assign to your item. |
| eBay_MinimumToBid | Starting Price | Enter in a numerical value | You can specify here what you want to set the minimum bid as for your eBay auction. |
| eBay_BuyItNowPrice | Buy It Now Price | Enter in a numerical value | You can specify here what you want the buy it now price to be for your eBay auction. |
| eBay_ReservePrice | Reserve Price | Enter in a numerical value | You can specify here what you want the reserve price to be set as for your eBay auction. |
| eBay_ListByUPC | List this product using eBay's UPC / ISBN database of pre-filled items. | Check Box, Checked = True; Unchecked = False. | Checking this Box will make it true, and it will use pre filled information from eBay, not checking it will make it false and not use any information from ebay. |
| eBay_IncludePrefilledItemInformation | List this product using eBay's UPC / ISBN database of pre-filled items. This option is available when the item was added by UPC. | Check Box, Checked = True; Unchecked = False. | If marked true, then it will list item with epid information, if marked false, then it will not use ebay catalog information. |
| eBay_ItemLocation | Use warehouse city, state | Check Box, Checked = True; Unchecked = False. | if marked true, then it will use warehouse city, state. if marked false, then it will not use warehouse city, state |
| eBay_EPID | EPID30971438 | Product identifiers, such as ePID values or ISBN values | |
| eBay_DaysToFullPayment | |||
| ebay_GSPShipping | GSP Shipping | Check Box, Checked = True; Unchecked = False. | Will enable the eBay Global Shipping Program |
| eBay_Duration | Duration | 1/3/5/7/10/30/GTC | You can specify here what you want your Fixed Price/Auction duration to be. Keep in mind not all eBay sites offer the same durations for listing types. |
| eBay_Title | Title | Enter a title that is 80 characters max in length. | You can override the items title and make an eBay specifc one, you may not have more than 80 characters with it. |
| eBay_SubTitle | Subtitle | Enter a subtitle here. | For an additional fee, you may add an eye catching subtitle to your listing that will appear under your title in eBay searches. You can include additional information you want to quickly tell the customer. |
| eBay_Gallery | Gallery | Gallery Plus | For a dollar more in insertion fees, you may include an enlarge picture option under your products thumbnails within eBay search results. |
| eBay_GalleryURL | Product Images (Multiple images can be added in this section) | Enter Value here. | Some sites do not have free gallery, and pay for this service. If you use this then eBay (if your site permits free gallery) will push your item and recategorize it as a PictureURL. |
| eBay_PhotoDisplayType | Picture Pack |
0 = Checkbox unchecked PicturePack = Checkbox checked |
This allows the ability to zoom in and magnify the eBay gallery picture. |
| eBay_UseKyozouPictureForList | Use Kyozou Picture For List | Check Box, Checked = True; Unchecked = False. | if marked true, then it will use the Kyozou picture for your item; if marked as false then the Kyozou picture will be neglected. |
| eBay_CategoryId | eBay Category | 12345 | You can get this number by either looking on the internet for ebay category ids, or making a listing, and going through our internal category database and getting the ID number from it. As a general note it is always helpful to get a cheat sheet of commonly used ones you will always pick for easy reference. |
| eBay_CategoryId2 | eBay Category #2 | 12345 | You can get this number by either looking on the internet for ebay category ids, or making a listing, and going through our internal category database and getting the ID number from it. As a general note it is always helpful to get a cheat sheet of commonly used ones you will always pick for easy reference. |
| eBay_AccountIDToUse | Seller | Enter eBay ID# | Under "Marketplace Seller Accounts & Settings" in your administration control panel. When you click it, under it appears a list of your account, ie (Ebay) (ID#) (Account Name). The ID# you see is the account id to use. |
| eBay_StoreCategoryId | Store category | 5135 | Contact your Kyozou account manager for help in getting these values. |
| eBay_StoreCategoryId2 | 2nd Store Category | 65655 | Contact your Kyozou account manager for help in getting these values. |
| eBay_TemplateID | Listing Template | Enter Listing Template ID# | You may get these values by going to your control panel, and clicking "Design Master/Template Builder" (option 10). Your eBay templates will be listed here with a number in quotes infront of it. The number in the quotes it that templates ID number which you may enter here. |
| eBay_SiteID | Site | 100 | 0 = United States 2 = Canada 3 = United Kingdom 6 = Ireland 15 = Australia 16 = Austria 23 = Belgium (French) 71 = France 77 = Germany 100 = Ebay Motors 101 = Italy 123 = Belgium (Dutch) 146 = Netherlands 186 = Spain 193 = Switzerland 196 = Taiwan 223 = China |
| eBay_CustomSpecifics | Custom Item Specifics | Size=16|*|Color=Blues|*|Shade=Bright Blue|*|Brand=kyozou|*|Material=Cotton Blend|*|Sleeve Length=Short Sleeve|*|Occasion=Holiday|*|Season=Summer | Separated by delimiter |*|, i.e. (Custom Specific)=(Value)|*| (Custom Specific)=(Value) |
| eBay_InternationalVisibility | International Site Visibility | Check Box, Checked = True; Unchecked = False. | If marked as true, then the item will be listed to other international eBay websites for a fee, it marked as false then the item will only list on the ebay site you listed it to. |
| eBay_Currency | Currency | USDollar/CanadianDollar/UKPoundSterling/AustralianDollar | You can specify what currency you accept for the item for eBay. |
| eBay_Country | Country | United States, Canada, United Kingdom, Etc… | You can specify the country in which the item is being shipped from. |
| eBay_CityState | City, State | New York, New York etc…. | You can specify which city/state the item is being shipped from. |
| eBay_HitCounter | Counter | 1/2/3/4/5 | eBay offers 5 different counters to help track how many times your item was visited. These numbers are shown when you visit the auction listing. |
| eBay_AllowBestOffer | Allow Best Offer | Check Box, Checked = True; Unchecked = False. | You can set your item to accept best offers or not. Keep in mind you can auto accept or decline them within the marketplace seller accounts and settings option (13) in the control panel |
| eBay_BestOfferAcceptAmt | Accept Best Offers at this amount | An amount of money | An amount of money less than the Buy It Now price. Best offers must be enabled. Different from the settings option (13) in the control panel |
| eBay_BestOfferDeclineAmt | Decline Best Offers at this amount | An amount of money | An amount of money less than the Buy It Now price and the Best offer accept amount. Best offers must be enabled. Different from the settings option (13) in the control panel |
| eBay_PayNow | Require Immediate Payment | Check Box, Checked = True; Unchecked = False | If true, then buyer will need to pay for it immediately, if marked false then buyer will not be forced to pay immediately after the auction is won. |
| eBay_ZipCode | Zip/Postal Code | Valid Zip/Postal Code | Enter a valid zip / postal code for the location |
| eBay_ReturnAccepted | Returns Accepted | Check Box, Checked = True; Unchecked = False. | If checked to equal true, then it will open up more options and allow buyers to return items. If unchecked, then you will not accept returns for this item. |
| eBay_RefundDetails | Refund Policy | We accept returns and exchanges only if the item is in mint condition and unopened in the package. | You are able to specify the return policy here, you are allowed only 500 characters though. Be as detailed as possible to avoid buyer confusion about your policy. |
| eBay_RefundType | Refund Type | MoneyBack, MerchandiseCredit, Exchange, MoneyBackOrExchange | You can specify what options are available to people who return items, if it is applicable. |
| eBay_PayPalEmail | PayPal Account To Use | Enter PayPal email address | Under "Payment recieving settings" in your administration control panel. When you click it, under it appears a list of possible payment accounts, ie (PayPal) (Email addres). The email address you see is the address to use. |
| eBay_RestockingFee | |||
| eBay_RefundWithin | Refund Timeframe | 3 Days, 7 Days, 14 Days, Etc…. | You can specify, if applicable, the timeframe a buyer has to return an item. |
| eBay_ItemCondition | Item Condition (Required) | New with Tags, New without tags, New with Defects, Preowned, etc... | You can specify the item condition here and pick the option that best suits your items, remember it is mandatory. You must look at the exact spelling as it's shown in Kyozou and use that value in your spreadsheet to populate correctly (it is case sensitive) |
| eBay_ItemConditionDescription | Item Condition Description | It isa new item, but the packaging is riped. | ebay will allow you to give a description of the condition of the item. |
| eBay_HandlingTime | Handling Time | 1,2,3,4,5,10,15,20 | This is to set your Handling time with eBay, it is the time you need to get the item ready to ship out |
| eBay_PrivateAuction | Private Auction | Check Box, Checked = True; Unchecked = False. | If marked as true, then it will make this item a private auction. If marked false, then it will not make the item a private auction. |
| eBay_OverrideExcludeFeature | Override Shipping Exclusions Profile | Check Box, Checked = True; Unchecked = False. | It marked as true, then you will override shipping exclusions profile. If marked as false, you will not override the shippign exclusions profile. |
| eBay_BlocksBiddersFromNotShippingCountries | |||
| eBay_BlocksBiddersFromShippingCountries | Black bidders who are registered in countries I do not ship to | Check Box, Checked = True; Unchecked = False. | If marked as true, then you will block bidders who are registered in countries you do not ship to. If marked as false, then you will not block bidders who are registered in countries you do not ship to. |
| eBay_UseExcludeCountryFeature | Use Exclude Country Feature | Check Box, Checked = True; Unchecked = False. | If inputted as true, then it will use the exclude country feature. If unchecked, then it will not include the exclude country feature. |
| eBay_ExcludeCountries | Select countries to exclude | AZ,DL,AS | Two digit country code, for the countries you wish to exclude. |
| eBay_DomesticShippingDiscountProfileID | Flat eBay shipping discount (Domestic) | Input the ID# (can be found in Control Panel - step 11, under the shipping details section) | Flat shipping rules let you offer discounts to buyers who purchase more than one of your items. You can charge for shipping the item with the highest shipping cost, and then add an additional lower cost for each additional item that they purchase from you. You can also subtract shipping costs for each additional item purchased, or offer free shipping on additional items. If you choose to subtract an amount you can choose to subtract a fixed dollar amount or a percentage of the shipping cost. These are set up on eBay and imported into Kyozou, ask an account manager for help. |
| eBay_InternationalShippingDiscountProfileID | Flat eBay shipping discount (international) | Input the ID# (can be found in Control Panel - step 11, under the shipping details section) | Flat shipping rules let you offer discounts to buyers who purchase more than one of your items. You can charge for shipping the item with the highest shipping cost, and then add an additional lower cost for each additional item that they purchase from you. You can also subtract shipping costs for each additional item purchased, or offer free shipping on additional items. If you choose to subtract an amount you can choose to subtract a fixed dollar amount or a percentage of the shipping cost. These are set up on eBay and imported into Kyozou, ask an account manager for help. |
| eBay_DomesticPromotionalShippingDiscount |
Use promotional eBay shipping discount (Domestic) |
Check Box, Checked = True; Unchecked = False. | When you create a promotional shipping rule, you can offer buyers special discounts if they buy multiple items or spend a certain amount. You can also charge a maximum shipping amount for a single order. They are imported to Kyozou after created on eBay, ask your account manager for help. |
| eBay_InternationalPromotionalShippingDiscount | Use promotional eBay shipping discount (International) | Check Box, Checked = True; Unchecked = False. | When you create a promotional shipping rule, you can offer buyers special discounts if they buy multiple items or spend a certain amount. You can also charge a maximum shipping amount for a single order. They are imported to Kyozou after created on eBay, ask your account manager for help. |
| eBay_ShippingCostPaidBy | Return Shipping Cost | Buyer / Seller | When an item is being returned this specifies if shipping is paid for by the seller or the buyer. |
| ebay_GSPShipping | Global Shipping Program | CheckBox, Checked = True; Unchecked = False. | Offer your items to be shipped using eBays Global Shipping Program |
| eBay_ShippingProfileId |
Business Policies - Shipping Profile ID |
1234567890 | The ID of the eBay shipping profile you want to use. When importing any business policies, all 3 business policies along with the eBay Seller & eBay Site must also be specified in the file. |
| eBay_ReturnsProfileId |
Business Policies - Returns Profile ID |
1234567890 | The ID of the eBay returns profile you want to use. When importing any business policies, all 3 business policies along with the eBay Seller & eBay Site must also be specified in the file. |
| eBay_PaymentProfileId |
Business Policies - Payment Profile ID |
1234567890 | The ID of the eBay payment profile you want to use. When importing any business policies, all 3 business policies along with the eBay Seller & eBay Site must also be specified in the file. |
| eBay_OutOfStock |
Out Of Stock Control |
CheckBox, Checked = True; Unchecked = False | Choose to enable/disable the eBay Out of Stock control. Only applicable to fixed price GTC listings. Allows the listing to remain active after all quantity of the product sells. |
| eBay_WarrantyAvailable | |||
| ADDITIONAL PRODUCT INFORMATION | |||
| ConsignorID | Consignor | 12345 | You get this value by going to the consignement section in the navigation, showing all. Beside the consigner name column is one that says ID, that is the value you would input here |
| RelistProfileName | Relist profile | Input a relist profile name | You get this value from the Listings Section, under auctions eBay--> Auto-lister profiles --> Auto-Relisting Profiles, simple type the profile name exactly here. |
| Classification__Classification Name | Product Classification name | Enter product classification Name | Enter Product classification name here. |
| Reference__Reference Name | Product Reference name | Enter a value for your refrence | these are custom fields associated with custom global references you create in the control panel (4) at the bottom of the page. You will always begin the column with Reference_ then end it with the name of the global reference. |
| AMAZON | |||
| amazon_ASIN | Amazon Item ID Type | Enter numerical value here. | You may choose to list this item to Amazon with an ASIN (Amazon Standard Identification Number) |
| amazon_UPC | Amazon Item ID Type | Enter numerical value here. | You may choose to list this item to Amazon with an UPC (Universal Product Code) |
| amazon_PriceCurrency | -= Select Currency =- | USD/ CAD/ EUR/ GBP/ JPY | Associate the Currency for your item with new items. |
| amazon_Price | Price | Enter a numerical value | You can set what you wish the price of your item to be on Amazon here for new items. |
| amazon_ProductType | Amazon Item ID Type | ASIN/ISBN/UPC/EAN | You may specify which amazon item ID type you wish to use. |
| amazon_ProductCondition | Condition | UsedLikeNew/UsedVeryGood/UsedGood/ UsedAcceptable/CollectibleLikeNew/ CollectibleVeryGood/Collectible Good/CollectibleAcceptable/UsedRefurbished/ Refurbished/New | Pick the appropriate condition of your product for Amazon to list. |
| amazon_Title | Title | Enter your product title | Enter a appropriate product title for your item to be listed to Amazon. |
| amazon_Quantity | Quantity | Enter a numerical value here. | The Quantity of your item to Amazon. |
| amazon_ProductNote | Condition Note | Input value here. | Enter any extra information you wish to list with your item to Amazon. |
| amazon_IsExpeditedShipping | Expedited Shipping | Check Box, Checked = True; Unchecked = False. | If marked as True, then Expedited Shipping will be used; if marked as false, then expedited shipping for your product will not be used. |
| amazon_IsShipInternationally | International Shipping | Check Box, Checked = True; Unchecked = False. | if marked true, then your product will ship internationally; if marked as false, then your item will not be shipped internationally. |
| amazon_SellerID | Amazon Account | Enter an account ID number. | This information is located in your control panel in the "marketplace seller accounts" (11). If you expand the list of your auction accounts you will see the ID number next to the words Amazon. |
| amazon_UseGeneralDescription | Use general description | Check Box, Checked = True; Unchecked = False. | if marked true, then products default description will be used; if marked false, then you will need to enter a description for your amazon listing for new items. |
| amazon_TemplateType | Item Type | AutoAccessory/Beauty/CameraAndPhoto/Clothing | This is Amazon category, it will list your item with the spreadsheet associated with the type of item you have. It is REQUIRED if any category-specific fields are present in the import file. |
| amazon_LeadTimeToShip | Leadtime to Ship (Handling time) | 1/2/3/4/5 | Set your handling time. |
| amazon_ShippingTemplate | Shipping Template | Anything | The template name must match identically to what you have created on Amazon. If the template name does not exist in Kyozou, it will create a new one. See kb article: http://kb.kyozou.com/knowledge-base/amazon-shipping-templates |
| amazon_PriceMin | Auto-Pricing - Minimum Allowable Price | 5.25 | Set your minimum allowable price when auto- pricing |
| amazon_PriceMax | Auto-Pricing - Maximum Allowable Price | 9.75 | Set your maximum allowable price when auto- pricing |
| amazon_PriceStep | Auto-Pricing - Lower Price By | 1.00 | Set the increment you which to reduce competitor's price by when auto-pricing |
| amazon_PriceType | Auto-Pricing - Compete with | ListingPrice, LandedPrice | Set which competitor price you'd like to compete with. ListingPrice: Item Price Only LandedPrice: Item Price + Shipping (The auto-pricing field will automatically become enabled when you use the 4 above fields) |
| amazon_FeedbackRating | Auto-Pricing - Feedback Rating | 98-100%,95-97%,90-94%,80-89% | Select the feedback ratings of other sellers you'd like your auto-pricing compete with. Use the pre-defined options you see and comma separated. |
| amazon_AutoPrice | Auto-Pricing - Enable or Disable | false/0/no/true/1/yes | false/0/no to Disable Auto-pricing. true/1/yes to Enable Auto-pricing. |
| Auto Accessory | Auto Accessory-specific fields | Excel file with the list of Auto Accessory fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Beauty | Beauty-specific fields | Excel file with the list of Beauty fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Camera And Photo | Camera And Photo-specific fields | Excel file with the list of Camera And Photo fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Clothing | Clothing-specific fields | Excel file with the list of Clothing fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Consumer Electronics | Consumer Electronics-specific fields | Excel file with the list of Consumer Electronics fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Food And Beverages | Food And Beverages-specific fields | Excel file with the list of Food And Beverages fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Gourmet | Gourmet-specific fields | Excel file with the list of Gourmet fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Handheld Software Downloads | Handheld Software Downloads-specific fields | Excel file with the list of Handheld Software Downloads fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Health | Health-specific fields | Excel file with the list of Health fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Home | Home-specific fields | Excel file with the list of Home fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Jewelry | Jewelry-specific fields | Excel file with the list of Jewelry fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Miscellaneous | Miscellaneous-specific fields | Excel file with the list of Miscellaneous fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Musical Instruments | Musical Instruments-specific fields | Excel file with the list of Musical Instruments fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Office | Office-specific fields | Excel file with the list of Office fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Pet Supplies | Pet Supplies-specific fields | Excel file with the list of Pet Supplies fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Software Video Games | Software Video Games-specific fields | Excel file with the list of Software Video Games fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Sound And Recording Equipment | Sound And Recording Equipment-specific fields | Excel file with the list of Sound And Recording Equipment fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Sports | Sports-specific fields | Excel file with the list of Sports fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Tires And Wheels | Tires And Wheels-specific fields | Excel file with the list of Tires And Wheels fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Tools | Tools-specific fields | Excel file with the list of Tools fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Toys Baby | Toys Baby-specific fields | Excel file with the list of Toys Baby fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Watches | Watches-specific fields | Excel file with the list of Watches fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Wireless | Wireless-specific fields | Excel file with the list of Wireless fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Books | Books-specific fields | Excel file with the list of Books fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Industrial & Scientific-Fasteners | Industrial & Scientific-Fasteners-specific fields | Excel file with the list of Industrial & Scientific-Fasteners fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Industrial & Scientific-Food Service and Janitorial, Sanitation, & Safety | Industrial & Scientific-Food Service and Janitorial, Sanitation, & Safety-specific fields | Excel file with the list of Industrial & Scientific-Food Service and Janitorial, Sanitation, & Safety fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Industrial & Scientific-Lab & Scientific Supplies | Industrial & Scientific-Lab & Scientific Supplies- specific fields | Excel file with the list of Industrial & Scientific-Lab & Scientific Supplies fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Industrial & Scientific-Other | Industrial & Scientific-Other-specific fields | Excel file with the list of Industrial & Scientific-Other fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Industrial & Scientific-Power Transmission | Industrial & Scientific-Power Transmission-specific fields | Excel file with the list of Industrial & Scientific-Power Transmission fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| Industrial & Scientific-Raw Materials | Industrial & Scientific-Raw Materials-specific fields | Excel file with the list of Industrial & Scientific-Raw Materials fields available. | For more details on how to fill each field in these files please visit https://sellercentral.amazon.com/gp/help/help-popup.html?ie=UTF8&itemID=1641. You must be already logged in to your amazon account to use this page. |
| PRODUCT LOCATION ASSIGNMENT | |||
| PlaceID | Shelf ID for filtering by Search Column or Full location name | Unique Shelf Id Value from Warehouse Management. | This value identifies the physical location of the product within the warehouse you are importing too. |
| NEWEGG | |||
| newegg_SellerID | Newegg Seller ID | Enter the seller account represented by a numerical value. | Every seller account is represented with a numerical value starting with 1,2,3 etc. For ex: If you want to use the first Newegg account then enter the value “1”. |
| newegg_UseMultiLister | Use for Multi-lister | Accepted values are “True” or “False”. | This field is used to specify whether or not you want to enable newegg venue for multilister. |
| newegg_ProductType | Newegg Item ID Type | Choose “New” or “Exist”. | Enter the product type. Choose “Exist” for an existing Newegg item. |
| newegg_Price | Newegg Listing Price* | Enter a listing price. | Enter the listing price for your Newegg item, for ex: “5”. |
| newegg_ItemNo | Newegg Item# | Enter Newegg item#. | This field is used to specify the Newegg item number, for ex: “45345”. |
| newegg_Manufacturer | Manufacturer * | Enter the manufacturer for your product. | |
| newegg_ManufacturerPart_ISBN | Manufacturer Part#/ISBN* | The manufacturer Part # or ISBN of the product. | Required if the item UPC or EAN is not provided. |
| newegg_UPC | UPC | Enter the UPC in this field. | |
| newegg_EAN | EAN | Enter the EAN in this field. | |
| newegg_ProductCondition | Condition | Accepted values are “New”, “Used Very Good”, “Used Like New”, “Refurbished”, “Used Good”, “Used Acceptable” | Enter the product condition such as “UsedLikeNew”, “UsedVeryGood” etc. |
| newegg_ProductConditionDetails | Condition Details | Specify condition details. | This field is used to specify the condition details for your item. This field will only appear for the Product Conditions such as “User like new”, “Used very good”, “Used good” and “Used acceptable”. |
| newegg_ItemPackaging | Item Packaging | Accepted values are “”Retail” and “OEM” | . |
| newegg_Shipping | Shipping | Accepted values are “Default” and “Free”. | If sellers pick default, then the item will charge shipping based on how Newegg charges shipping for the item. Sellers can refer to Estimated Shipping Charge and get an idea of how the default setting will affect the shipping charge for the item. If sellers pick free, then the item will not charge shipping for the item’s default shipping method. |
| Walmart | |||
| walmart_SellerId | Walmart Seller ID | Enter the seller account represented by a numerical value. | This information is located in your control panel in the "marketplace seller accounts" (11). If you expand the list of your auction accounts you will see the ID number next to the words Walmart. |
| walmart_StartDate | Sale Start Date | Accepted values are dd-mm-yyy | This field is used to specify whether or not you want to enable a Sale on your product |
| walmart_EndDate | Sale End Date | Accepted values are dd-mm-yyy | Enter an end date for your Sale. |
| walmart_Price | Walmart Listing Price* | Enter a listing price. | Enter the listing price for your Walmart item, for ex: “5”. |
| walmart_ProductTaxCode | Walmart Product Tax Code* | Enter a 7 digit Walmart Tax Code. | Enter the product tax code for your Walmart item, for ex: “2038710”. |
| Shopify | |||
| shopify_SellerId | Shopify Seller Id | Accepted value is the Kyozou number assigned to your seller | Enter the number found in Control Panel Step 11 |
| shopify_Title | Title for Product | Enter a name/title .. | Enter the name/title for your Shopify item. |
| shopify_Price | Selling Price for Product | Enter a listing price. | Enter the listing price for your Shopify item, for ex: “5”. |
| shopify_Tags | Shopify Tags | Enter a comma-separated list of tags/words. ie. "Cotton, Taiwan" | Enter the tags/words to Shopify categorize your product. |