LAYLA CLIENT MANUAL- PRODUCT INFORMATION BULK REGISTRATION -©2018 TMH Inc. All Rights Reserved.

Confidential

Contents
1. Download “LAYLA_BulkUpload_Template” from LAYLA-EC.COM
2. Fill in necessary information on “LAYLA_BulkUpload_Template” and convert the template fromexcel to csv format
3. Upload the “LAYLA_Bulk_UpLoad_Template” to LAYLA-EC.COM

1©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

4. APPENDIX

1. Download “LAYLA_BulkUpload_Template” fromLAYLA-EC.COM

2©2018 TMH Inc. All Rights Reserved.

Confidential3©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 1. In order to download “LAYLA_BulkUpload_Template” click on “Learn to sell”

4©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 2. Scroll down “Learn to sell” page

Step 3. Download “LAYLA_BulkUpload_Template” from the bottom of “Learn to sell” page

5

©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Please click here to download
the templateStep 4. Save “LAYLA_BulkUpload_Template” (excel format) to your PC

6©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Double click to open the file2. Fill in necessary information on“LAYLA_BulkUpload_Template” and convert the
template from excel to csv format

7©2018 TMH Inc. All Rights Reserved.

Confidential

Step 1. Open and enable editing “LAYLA_BulkUpload_Template”

8©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Please click on “Enable Editing”

Step 2. Fill in the necessary item information

Yellow-shaded columns are mandatory field. However, you may always place “-”or “unknown” etc. if the information is not yet prepared.
*Please refer the APPENDIX for more details.

Though you may register items with using vague terms (“-”, “unknown” etc.),
more accurate item information means more chance to be sold.

9©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Please refer to these sheet tabs for information field
description, category list, and master country code list

Step 3. Fill in the necessary item information

Seller SKU code (mandatory):➢ A unique ID for identifying the item on LAYLA. It is recommended to use the same unique ID with the one already used for other EC
site etc.
Part number / Model number (mandatory but either entry is fine):➢ Either “Part number” or “Model number” is mandatory to enter. You may also enter “-” (hyphen) if both part number and model
number are not recognized.
Item name / Part manufacturer / Tool manufacturer / Tool name (mandatory):➢ You may also enter “-” (hyphen) if any of these information is not recognized.
Process:➢ Indicating which semiconductor manufacturing process is an item used for. You may select “900: -” if the information is notrecognized.
Wafer size:➢ Size of wafer used for a semiconductor manufacturing tool. You may select “80: unknown” if the information is not recognized.
Condition ID:➢ Condition of item.

10©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

You may leave the mandatory information fields as “-” or“Unknown”; however, please be reminded that moreaccurate information provided means greater chance to be
sold on LAYLA.

Step 4. Fill in the necessary item information

Warranty➢ Insert a number of days you provide as warranty.
Warranty definition:➢ Select one from the pull-down. You may select “4: No warranty” as well.
Ship from Country:➢ Country code can be found on sheet tab, “MSTcountry”,
Transportation:➢ Classification of freight cost (1: Flat: Same cost to all buyers; 2: Free: Free shipping; 3: Calculated: Cost varies by buyer location)*Since LAYLA-EC.COM currently does not have automated shipping price calculation and the price adjustment is available at the time ofsale, it is recommended to choose 1: Flat: Same cost to all buyers and enter the guesstimated abundance shipping price for “Freightcosts calculated domestic” and “Freight costs” to ensure seller will not lose money by delivering.
From TMH Inc. experience, USD 300 is enough for shipping covering almost all locations and most items (parts).
**A new classification, “4: Ask,” will be added soon (currently under system development). When it’s deployed, sellers do not need toenter any freight cost. Freight costs is determined by communicating with buyer at time of each sale.
Freight costs calculated domestic:➢ Domestic freight cost

11

©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Freight costs:➢ The freight cost entered is effective when "3" is entered in "Transportation“ (*Delivery price/method negotiable)

Step 5. Fill in the necessary item information

Delivery:➢ Days required for shipping after received order
Delivery service:➢ Days required for delivery (1: First class service (1 to 3 business days); 2: Express service (1 to 5 business days); 3: Standard
service (1 to 9 business days); 4: Economy service (more than 10 business days))Category2:➢ Subcategory of items*Category2 selected is applied to which category is the item displayed on LAYLA.
**Category 1 is automatically determined when category 2 is selected.
Disp list flag:➢ 1: Display; 0: Not Display*”0: Not Display” means the item is still available but not displayed through “Search” items.
Active SKU flag:➢ 1: Active; 0: Soft Delete*”0: Soft Delete” means the item is sold out or unavailable for sale.

Quantity:➢ Quantity of sellable items
12©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Domestic Price:➢ Domestic selling price. (Sales tax and other duties shall be taken into consideration for domestic selling price. Price can be the same
if no need to consider taxes and duties. When seller answers “Supply” to “Demand”, “Supply” price should not be lower than 90% of“Demand” price's lower limit)
Price:➢ International selling price. (When seller answers “Supply” to “Demand”, “Supply” price should not be lower than 90% of “Demand”
price's lower limit)13©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 6. The sheet tab, “description”, provides the detailed information of the bulk upload template info fields

14©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 7. The sheet tab, “category”, provides category code for Category 1 and 2

15©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 8. The sheet tab, “MSTCountry”, provides country code

16©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 9. Once bulk item registration file is created, save it as csv. format by clicking “save as”

17©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 10. Select “CSV UTF-8 (Comma delimited)(*.csv)”

18©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 11. Click “Save”

19©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 12. When pop-up window shows up, click “OK” to save as csv. format (pop-up window shows up twice
depending on your PC environment

20©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 13. Close the file21©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 14. When pop-up window shows up, click “Save”

22©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 15. The file is saved

Step 16. *Please avoid editing the item data in the csv. file itself. It may cause the change in data fields and theupload may not be reflected properly.

23©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

When you need to edit the item data, edit thedata in the excel format. When completed,save it as csv. format again.

3. Upload the “LAYLA_Bulk_UpLoad_Template” to
LAYLA-EC.COM

24©2018 TMH Inc. All Rights Reserved.

Confidential25©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 1. Login to your seller account26©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 2. Enter your registered email address and password

27©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 3. Click “Product information bulk registration” from “Seller Menu” on “My Layla”

Step 4. Click “Browse…” *Tick “Leave the first line blank for space of headline” when applicable

28©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

If the first line of the csv. file is for title (template itself has thefirst line for title), tick the “Leave the first line blank for space ofheadline” checkbox.

29©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 5. Select the file (csv. format) and click “Open”

30©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 6. Selected file (csv. format) name is appeared and click “Register”

31©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

Step 7. Click “Register” again and the bulk upload job is started. The bulk upload result notification is sent toregistered e-mail address shortly*The bulk upload job batch runs every five minutes.

Step 8. Your bulk upload job is processing

If the bulk upload result notification e-mail is notsent within 20 minutes or so, please contact
LAYLA Customer Support Team:✉customer@layla-ec.com

32©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker℡ +81-97-576-7262

Step 9. The bulk upload result notification e-mail is sent to your registered e-mail address

33©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

When the bulk upload job is failed, erroneous
data is indicated in the e-mail content.

4. APPENDIX

34©2018 TMH Inc. All Rights Reserved.

Confidential

APPENDIX: The details of “LAYLA_BulkUpload_Template” data fields

SEC

1

2

Item name

Required

Seller SKU code

Part number○△

Unique○Character typeHalf-widthalphanumericHalf-widthalphanumeric

Number ofcharacters

5080Remarks
SKU (Stock-Keeping Unit) code is toparticularly identify the listed item. SKUs
can be defined by sellers or automatically
numbered if not defined.
※When individual number for each item isnecessary, SCU is frequently used to linkwith seller's inventory management systemin the case of large-quantity items' listing.

Part Number that is numbered by tool
manufacturer
Either Part number or model number isrequired

Model name specified by each manufacturer

Model number△

4

Item name○All©2018 TMH Inc. All Rights Reserved.

Confidential

80

80

Either Part number or model number isrequiredName of certain item
Document Tracker

35

3

Half-widthalphanumericAPPENDIX: The details of “LAYLA_BulkUpload_Template” data fields

Item name5Part
manufacturer○

Half-widthalphanumeric

80

Name of Parts Manufacturer

6

Tool
manufacturer○

Half-widthalphanumeric

80

Name of Tool Manufacturer

Tool name

○

All

255

Model name of particular tool7

Required

UniqueCharacter type

Number ofcharacters

SEC

Remarks

10:ETCH (DRY)

Process
8(Process ofmanufacturing
semiconductors
products)○

Half-width numbers 255

20:CVD
30:IMPLA
40:PVD（METAL）
50:METROLOGY (IQC)
60:CMP
70:LITHO
80:ETCH（WET）
90:HOT (LP-CVD, DIFFUSION, RTP)
100:EPI
110:TEST
120:ASSEMBLY
900:-

36

©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker",“ Multiple specifications can be
specified as a delimiter ex.1,2,4,7

APPENDIX: The details of “LAYLA_BulkUpload_Template” data fields

SEC

Item name

Required

UniqueCharacter type

Number ofcharacters

Remarks
10:6inch(150mm)
20:8inch(200mm)

Wafer size
9(Size of wafer
used/processedon semiconductor
manufacturing
tool)

30:12inch(300mm)○

Half-width numbers

255
80:unknown
90:other","More than one can be specified asa delimiter ex.1,2,4,5※When registered as blank, initialvalue "5" is set.

37

Half-widthalphanumeric

Serial number©2018 TMH Inc. All Rights Reserved.

Confidential

255

Individual number for identifying
product individually

Document Tracker

10

APPENDIX: The details of “LAYLA_BulkUpload_Template” data fields

SEC

Item name

Required

UniqueCharacter type

Number ofcharacters

Remarks
110: OEM New(New item)
120: OEM OPM New(New item manufactured by OriginalParts Manufacturer with different
marking and label)130: OEM Used O/H by manufacturer(refurbished by original manufacturer)
140: OEM (Used item) O/H by 3rdparty(O/H by non-original manufacturer)

11

Condition ID○

Half-width number

10

150: OEM (Used item) Tested(Used andtested)160: OEM Used Working, Untested(Used item) Working, Untested (Taken
out from working tool, untested)
170: OEM Used As-Is, Unknown
210: 3rd New
220: 3rd Used O/H by manufacturer
230: 3rd Used O/H by 3rd party
240: 3rd Used and Tested
250: 3rd Used Working, Untested(Used item) Working, Untested (Taken
out from working tool, untested)38©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

260: 3rd Used As-Is, Unknown

SEC

Item name

Required

UniqueCharacter type

Number ofcharacters

Remarks

12

Condition
Description

All

1000

Supplementary description of item
condition

13

Shipping Policy

All

1000

14

Payment Policy

All

1000

15

Return Policy

All

1000

16

Warranty○

Half-width number

417

Warranty Definition○

Half-width number

1

18

Ship from Country(Country of
shipment origin)○

Half-width number

3

19

Transportation○

Half-width number

1

Supplementary information about
shipping methods
Supplementary information about
payment methods
Supplementary information about
returnWarranty period
The initial value is set to "0“
A certain promise by seller to offer
free repair, replace or refund tobuyer when product develops a
fault under a proper operatingmanner within a particular periodof time.
1: days after shipped
2: days after received
3: days after installation
4: No warranty
Definition of warranty period. The
initial value is set as "1"
Enter country name to ship
product with 3 letter as countrycodeEx) 156(China),
158(Taiwan),410(Korea),
392(Japan), 840(US)1: Flat: same cost to all buyers
2: Free: Free shipping
3: Calculated: Cost varies bybuyer location

39©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

APPENDIX: The details of “LAYLA_BulkUpload_Template” data fields

SEC

20

21

22

23

40

Item name

Freight costs
calculated US

Freight costs
calculated China

Freight costs
calculated Taiwan

Freight costs
calculated Korea©2018 TMH Inc. All Rights Reserved.

Required

○

○

○

○

Confidential

UniqueCharacter typeHalf-width number

Half-width number

Half-width number

Half-width number

Number ofcharacters

Remarks

10

The freight cost entered is effective
when "3" is entered in"Transportation." The freight costmust be entered as "0", when "1" or"2" is entered in "Transportation"※ This field is mandatory. Twodecimal places are available

10

The freight cost entered is effective
when "3" is entered in"Transportation." The freight costmust be entered as "0", when "1" or"3" is entered in "Transportation"※ This field is mandatory. Twodecimal places are available
two decimal places

10

The freight cost entered is effective
when "3" is entered in"Transportation." The freight costmust be entered as "0", when "1" or"4" is entered in "Transportation"※ This field is mandatory. Twodecimal places are available

10

The freight cost entered is effective
when "3" is entered in"Transportation." The freight costmust be entered as "0", when "1" or"5" is entered in "Transportation"※ This field is mandatory. Twodecimal places are available
Document Tracker

APPENDIX: The details of “LAYLA_BulkUpload_Template” data fields

SEC

24

25

Item name

Freight costs
calculated Japan

Freight costs
calculated Other

26

Freight costs
calculated Domestic

41©2018 TMH Inc. All Rights Reserved.

Required○○○

Confidential

UniqueCharacter typeHalf-width number

Half-width number

Half-width number

Number ofcharacters

Remarks

10

The freight cost entered iseffective when "3" is entered in"Transportation." The freight costmust be entered as "0", when "1"
or "6" is entered in"Transportation"※ This field is mandatory. Twodecimal places are available

10

The freight cost entered iseffective when "3" is entered in"Transportation." The freight costmust be entered as "0", when "1"
or "7" is entered in"Transportation"※ This field is mandatory. Twodecimal places are available

10

The freight cost entered iseffective when "3" is entered in"Transportation." The freight costmust be entered as "0", when "1"
or "8" is entered in"Transportation"※ This field is mandatory. Twodecimal places are available
Document Tracker

APPENDIX: The details of “LAYLA_BulkUpload_Template” data fields

APPENDIX: The details of “LAYLA_BulkUpload_Template” data fields

Item name27

Freight costs
calculated country1

28

Freight costs
calculated delivery
fee1

29

Freight costs
calculated country2

30

Freight costs
calculated delivery
fee2

31

Freight costs
calculated country3

32

Freight costs
calculated delivery
fee3

33

Freight costs
calculated country4

34

Freight costs
calculated delivery
fee4

35

Freight costs
calculated country542©2018 TMH Inc. All Rights Reserved.

Required

△

△

△

△

Confidential

UniqueCharacter type

Number ofcharacters

Half-width number

3Enter any shipping country code。

Half-width number

10

Required if the Freight costs calculated
country1 has been input.

Half-width number

3Enter any shipping country code

Half-width number

10

Required if the Freight costs calculated
country2 has been input.

Half-width number

3Enter any shipping country code

Half-width number

10

Required if the Freight costs calculated
country3 has been input.

Half-width number

3Enter any shipping country code

Half-width number

10

Required if the Freight costs calculated
country4 has been input.

Half-width number

3Enter any shipping country code

Remarks

Document Tracker

SEC

APPENDIX: The details of “LAYLA_BulkUpload_Template” data fields

Item name36

Freight costs
calculated delivery
fee5

37

Freight costs
calculated
country6

38

39

40

41

42

43

43

Freight costs
calculated delivery
fee6
Freight costs
calculated
country7
Freight costs
calculated delivery
fee7
Freight costs
calculated
country8
Freight costs
calculated delivery
fee8

Required

△

△

△

△

Freight costs
calculated
country9©2018 TMH Inc. All Rights Reserved.

Confidential

UniqueCharacter type

Number ofcharacters

Remarks

Half-width number

10

Freight cost for the country5 entered.
Required if "Freight costs calculated
country1" is entered.

Half-width number

3Enter any country code for freight costcalculation

Half-width number

10

Freight cost for the country6 entered.
Required if "Freight costs calculated
country1" is entered.

Half-width number

3Enter any country code for freight costcalculation

Half-width number

10

Freight cost for the country7 entered.
Required if "Freight costs calculated
country1" is entered.

Half-width number

3Enter any country code for freight costcalculation

Half-width number

10

Freight cost for the country8 entered.
Required if "Freight costs calculated
country1" is entered.

Half-width number

3Enter any country code for freight costcalculation
Document Tracker

SEC

APPENDIX: The details of “LAYLA_BulkUpload_Template” data fields

SEC

44

45

46

Item name
Freight costs
calculateddelivery fee 9
Freight costs
calculated
country10
Freight costs
calculateddelivery fee 10

Required△

UniqueCharacter type

Number ofcharacters

Half-width number

10

Freight cost for the country9 entered.
Required if "Freight costs calculated
country1" is entered.

Half-width number

3Enter any country code for freight
cost calculation

Remarks△

Half-width number

10

Freight cost for the country10 entered.
Required if "Freight costs calculated
country1" is entered.

47

Freight costs○

Half-width number

10

Flat shipping fee when "Flat same cost to
all buyers" is selected for"Transportation".

48

Delivery○Half-width number

4

Days required for shipping after
received order
Days required for delivery
1: First class service (1 to 3 business days)

49

Half-widthalphanumeric

Delivery service

50

2: Express service (1 to 5 business days)

4: Economy service (more than 10
business days)
44©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

3: Standard service (1 to 9 business days)

APPENDIX: The details of “LAYLA_BulkUpload_Template” data fields

SEC

Item name50

Delivery Note

51

Category1

52

Category2

Required○

UniqueNumber ofcharacters

RemarksAll

255

Describe special notes related to delivery,such as delivery outside region, shipping
method, shipping costs etc.

Array format

50

Major category of items. It is set
automatically by setting the Category2

Array format

50

Subcategory of items (belongs to major
item categories)

Character type

0:Not Display

53

Disp list flg○

Half-width number

1
1:Display

0:Soft Delete

54

Active SKU flag○

Half-width number

1
1: Active○

45©2018 TMH Inc. All Rights Reserved.

Confidential

Half-width number

20

Document Tracker

Domestic price55

USD decimal point 2 digit display
In the United States, Taiwan domestic,
Korean domestic, etc., if you want to sell
your product by eliminating theconsumption tax and display it
as tax-included priceAPPENDIX: The details of “LAYLA_BulkUpload_Template” data fields

46

Item name

56

Price

57

Keyword58

Description

59

60

Required○

UniqueCharacter type

Number ofcharacters

Remarks
USD decimal point 2 digit is displayed
International selling price※When seller answers Supply to
Demand, Supply Price should not belower than 90% of Demand Price's lower
limit.
Enter keywords separated by commas (,)
Keywords when Buyers use
to search for items※Register keywords that you wish to be
tracked on Buyer's search results(e.g.: OEM NEW, same day
shipping possible etc.)

Half-width number

20

All

255

△

All

10000

Detailed description of the item

Item Spec

△

All

1000

Detailed description of the item Spec

Quantity○

Half-width number

10

Quantity of sellable items©2018 TMH Inc. All Rights Reserved.

Confidential

Document Tracker

SEC