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.
- Choose all of the cells.
- Click “Replace” from Edit menu.
- Press “Ctrl”+”J” keys in the column in which the character string should be searched. This action means return, and nothing is represented there.
- Type in ” ” in the replacing column.
- Then click “Replace All.”
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.
|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