• Collective item registration format

    Collective registration and renewal of item data
    Click “Collective registration item” button. It shows up when you click “Show the Operation field” button in “Master Items: Welcart Shop Item list ” page. Then, choose your prepared Excel file and click “Registration start” button.

    In case of error occurring during registration and renewing, the log will be recorded. If there is no problem, the log will not be recorded. Also, the log will be renewed at every collective registration. The location where the log will be recorded is: “usc-e-shop/logs/itemcsv_log.txt”.

    [When you use Excel (recommended)]
    Excel file can be uploaded directly.
    Prepare the data as in the following data format below.
    Since CSV cannot represent every data in it, using Excel file is strongly recommended.


    [When you use CSV file]
    The data will be in CSV format (SJIS). Commas cannot be used.
    When the cell is returned, the return needs to be substituted into ” ” and saved as CVS format. The translation method is as follows.

    1. Choose all of the cells.
    2. Click “Replace” from Edit menu.
    3. Press “Ctrl”+”J” keys in the column in which the character string should be searched. This action means return, and nothing is represented there.
    4. Type in ” ” in the replacing column.
    5. Then click “Replace All.”


    [Data format]
    White=basic info, Blue=SKU info, Yellow=option info

    Item Name Input Value Application
    Single Byte Character is recommended. ex) ABC1002
    Item Names 20 characters or less is recommended. ex) enamel handbag (large)
    Limit number for purchase number (whole number) Zero (0) indicates unlimited.
    Point rate number (whole number) Zero (0) indicates no point given.
    Business package discount 1- numbers number (whole number) Zero (0) indicates unused. Less than “Business package discount 2- numbers”
    Business package discount 1- rate number (whole number) Zero (0) indicates unused. More than one (1) when the “number” is set.
    Business package discount 2- numbers number (whole number) Zero (0) indicates unused. Less than “Business package discount 3- numbers”.
    Business package discount 2- rate number (whole number) Zero (0) indicates unused. More than one when the “number” is set.
    Business package discount 3- numbers number (whole number) Zero (0) indicates unused.
    Business package discount 3- rate number (whole number) Zero (0) indicates unused. More than one when the “number” is set.
    estimated shipping date. number (whole number) 0: unspecified, 1: immediately, 2: 1~2days, 3: 2~3days, 4: 3~5days, 5: 4~6days, 6: about 1 week later, 7: about 2 weeks later, 8, about 3 weeks later, 9: after we get new items
    shipping option semicolon (;) delimiter shipping option ID (setting shipping option is first)
    shipping option ID (setting shipping option is first)
    shipping option ID is a number which is represented before the name of shipping in the shipping designate window.
    only one (ex): 1 , multiple (ex) : 2;3
    Shipping (price) character string name of shipping price (setting shipping price is first)
    Individual postage charge Numerical value (integral whole number) 0: unspecified, 1: specified
    Detail of page title character string
    Detail page body character string
    Detail page selection character string
    Appearance character string publish: published, future: reserved, draft: draft, pending: waiting for reviews
    Publish date character string 0000-00-00 00 : 00 : 00 (type in with character string as a cell format )
    or 0000/00/00 00 : 00 ( v 0.9)
    When it is blank, current date and time will be represented there.
    When you set “future : reserved” as the appearance, the future date and time should be set.
    Category semicolon (;) delimiter ID (setting category is first). Category “Items” is necessary. It has to be included there. If category “Items” is 3 and “Item recommended” is 5, they will be like below.
    ex) 3;5
    Tag semicolon (;) delimiter Item code of option items
    only one (ex): AS0012
    multiple (ex): AS0012;SD1025
    SKU code single byte character is recommended It can be set at whatever you like as long as the code is not repeated in the same item.
    ex) Item code + branch number or etc (If there is only one SKU code, it can be the same as the item number.)
    SKU display name character string ex) size S
    Regular price number Comma cannot be used. (The column will be blank if regular price column is not typed in.)
    Sale price number no comma
    Stock (stock number) number The column will be blank when you do not control inventory.
    Stock status number 0: In Stock, 1: Only few left in Stock, 2: Sold Out, 3: Out of Stock, 4: Out of Print
    Unit character string ex) dozen
    Apply business package number 0: Not apply, 1: Apply
    Option name character string It should be set as common option.
    ex) setting of Gift Wrapping
    Input field number 0: Single-select, 1: Multi-select, 2: Text, 3: Text-area
    Required field number 0: Not Required, 1: Required
    Select amount semicolon (;) delimiter If it is text field, will be blank.
    ex) Not specified; need; don’t need



    sample of normal items (Collective_registration_items.xls)


    DL Seller sample of professional item(Collective_registration_items_dlseller.xls)