iZySolutions - Documentation

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 20 Next »

The commercial file is a complementary file requested by GrandVision in order to complete the product information that is not present in the SF6 format.

The aim is to provide a maximum of commercial information on packaged products.

As a reminder: a packaged lens is a lens that includes an option which is generally a coating.

Commercial file template:

HOW TO FILL GRANDVISION COMMERCIAL FILE?

Columns

Section

Data

Data description

Mandatory / Conditional / Optional

Type

Format/Length

Examples

A

Product identification

 

 

 

 

 

Global Master Code *

Global Master Code
Product code in the group catalog (if available)

Mandatory if product code is available in the group catalog

Text

6 max

100067

100068

100088

200124

B

SF6 Lens Code *

SF6 Lens Code
Generic lens in the SF6 File

Mandatory

Text

6 max

DSK16C

DSK16T

IZ1501

ST0238

C

Article Description *

Product Name
Name of the packaged product (Baselens + Coating)

Mandatory

Text

40 max

DESK IZY 1.6 HARD COAT

DESK IZY 1.6 TR BROWN HARD COAT

IZY FF 1.5 SHORT BLUCUT SUPER AR

SV iZy Stock 1.5 HMC

D

VAC (Vendor Article Code) *

Vendor Article Code (VAC)
Order code of the packaged product

Mandatory

Text

10 max

DSK16CHC

DSK16TBC

IZ1501SAR

ST0238HMC

E

Base Lens Name *

Base Lens Name
Base Lens category

Mandatory

List

40 max

DESK IZY 1.6

DESK IZY 1.6 TR

IZY FF 1.5

iZy Stock 1.5

F

Stock Lens

Indicate if the lens is a Stock or not

Read only, just for information, any modification on this column will not change anything

Yes/No

No

No

No

Yes

G

RX Lens Code *for PbP

Associated RX Lens Code
RX lens package associated with Stock lens package
Mandatory if Lens is Stock

Mandatory only for Stock lenses

If the lens is not a stock the code will be ignore

Text

SV2526

H

Treatment information

 

 

 

 

Coating Code

Integrated Coating Code
Coating treatment in the package version
Empty if Uncoat

Mandatory if uncoat put N/A

Text

6 max

HC

HC

SAR

HMC

I

Coating Description

Mandatory if a coating code is set

Hard Coat

HMC

J

Coating Color

List

Brown

K

Supplier Lens Color Description *

Lens Color Description
Tint of the lens

Mandatory

Text

40

Clear

Photochromic Brown

Clear

Clear

L

Lens Appearance *

Lens Appearance
Type of tint (Gradient, …)

Mandatory

List

16

Clear/None

Clear/None

Clear/None

Clear/None

M

Commercial data

 

 

 

 

 

 

Label *

Brand Name
Brand

Mandatory

Text

DESK

DESK

IZY FF

SV

N

Sub Label

Collection Name
Collection

Mandatory

Text

SHORT

O

Material *

Material
Material (Commercial name)

Mandatory

Text

MR_8

MR_8

CR39

CR39

P

Country of Origin *

Country of Origin
Country of the product

Mandatory

By default it’s the country of your company.

Text

FR

FR

FR

FR

Q

Lens Design *

Lens Design

Mandatory

List

Standard

Standard

Aspheric

Spheric

R

Design Variant * for freeform lenses

Design Variant
Style of use
Mandatory if lens is Freeform

Conditional, empty if FreeForm Produced is No

List

None

None

Flex

None

S

Technology

Technology
Mandatory if lens is Freeform

Conditional, empty if FreeForm Produced is No

List

No

No

Individual

No

T

Technical specifications

 

 

 

 

Blue Cut Material *

Blue Cut Material
Blue light cut in the mass

Mandatory

Yes/No

Yes or No

No

No

Yes

No

U

Photochromic *

Indicate if the lens is photochromatic

Mandatory

List

Yes - UV light

Yes - UV + visible light

No

No

Yes

No

No

V

Photocromic Activation WaveLength * for photochromic lenses

Photocromic Activation WaveLength
Mandatory if lens is Photochromic

Mandatory Indication in nm value. It is use to know if the lens can be tint behind a window

Integer

xxx

390

W

Polarized *

Indicate if the lens is polarized

Read only, just for information, any modification on this column will not change anything

Yes/No

No

No

No

No

X

UV Protection *

Indicate if the lens is UB blocking

Read only, just for information, any modification on this column will not change anything

Yes/No

No

No

No

No

Y

FreeForm Produced *

FreeForm Produced
Freeform technology

Mandatory

Boolean

Yes or No

No

No

Yes

No

Z

Absorption *

Absorption (in %)
Global UV absorption (%)

Mandatory

Integer

0 min

100 max

85

AA

Minimum to Top

Minimum to Top (in mm)
The minimum distance (mm) needed from pupil to the top of the frame/lens

Integer

xx

15

AB

Pricing information

 

 

 

Supplier Introduction Date *

Supplier Introduction Date
Introduction Date of the packaged product

Mandatory

Date

YYYY-MM-DD

2013-02-14

2013-02-14

2021-12-01

2031-02-14

AC

Supplier Discontinuation date

Supplier Discontinuation date
End Date of the packaged product

Mandatory if the the supplier SKU Status = Phase Out

Date

YYYY-MM-DD

AD

Supplier SKU Status

Supplier SKU Status
Product status

Mandatory

List (see blelow)

9 max

Active

Active

New

Active

AE

Market restriction
Country-Banner Restriction

If empty : the product is available everywhere
If one or several country-banner are selected (multiselection possible) : the product is only available in the selected country-banners

Text

AF

Supplier Recommanded Retail Price (optional)

Supplier Recommanded Retail Price
Recommended selling price for the product

Mandatory

Decimal

xxx.xx

10

15

53

AG

Logistic information

 

 

 

 

Length *

Package Length (in mm)

Mandatory

Integer

xxx

80

80

80

80

AH

Width *

Package Width (in mm)

Mandatory

Integer

xxx

80

80

80

80

AI

Height *

Package Height (in mm)

Mandatory

Integer

xxx

80

80

80

80

AJ

Gross Weight *

Package Gross Weight (in g)

Mandatory Fill y default 19

Integer

xxx

19

19

19

19

AK

Net Weight *

Package Net Weight (in g)

Mandatory Fill y default 18

Integer

xxx

18

18

18

19

List of possibilities for:

Lens Appearance Label

Material

Lens Design

Design Variant * for freeform lenses

Technology

YesNo

Base Lens

Brand

Collection

Supplier SKU Status

Solid

Polycarbonate

Aphake

40

Traditional

Yes

Depend your product list

New

Gradient

CR39

Aspheric

A

Optimised

No

Active

Bi-Gradient

NXT / Trivex

Bifocal

Act

Individual

Phase Out

Clear/None

Silica / Mineral

Double Aspheric

All

Lifestyle

Filter<15% absorption

MR_6

Enhanced Reader

B

Tri-gradient/3-color graduated tint

MR_8

Individual

BC

MR_10

Individual Occupational

Book

MR_174

Lenticular

CI

Lifestyle

Driving

Lifestyle Occupational

EC

Multi Aspheric

Exp

Myopia Control

Far

Office Vocational

Flex

Optimised

L

Progressive

M

Progressive Lenti

Maxi

Relax Vision

Near

Round

None

Specialist

Office

Spheric

P0.5

Standard Occupational

P0.8

Trifocal

P1.1

PC

Proxi

Room

S

V

XS

List of possible errors you can have on your import:

  • [Warning]: The Base Lens XXX does not exist

    • The lens is not on the SF6 or/and not exists in iWi

  • [Warning]: The coating color is present but there is no lens appearance at line YYY

    • Reason : Coating color is not like None or Clear AND lens apparence is Clear/None

  • [Warning]: The Lens Appearence is present but there is no Coating color at line YYY

    • Reason : Lens apparence is not like Clear/None AND CoatingColor is None or empty AND SupplierLensColorDescription is"None" or empty

  • [Warning]: The brand code XXX is unknown

    • 1 - You must check this data conformity on the file (sensitive case, expected entry)

    • 2 - You must contact GV to ask them to create this new one.

  • [Warning]: The Collection code XXX is unknown

    • 1 - You must check this data conformity on the file (sensitive case, expected entry)

    • 2 - You must contact GV to ask them to create this new one.

  • [Warning]: Technology (Integrated Lens): Mandatory data on line YYY

    • If column FreeForm Produced is filled with Yes this data must contains value. See enumarated values Technology

  • [Warning]: Design variant for FreeForm lenses (Integrated Lens): Mandatory data on line YYY

    • If column FreeForm Produced is filled with Yes this data must contains value. See enumarated values Design variant for FreeForm lenses

  • [Warning]: The value XXX is not correct for the specific data Material at line YYY

    • You must check this data conformity on the file (sensitive case, expected entry). See enumarated values Material

  • [Warning]: The value XXX is not correct for the specific data Lens Design at line YYY

    • You must check this data conformity on the file (sensitive case, expected entry). See enumarated values Lens Design

  • [Warning]: The value XXX is not correct for the specific data Lens Appearance Label at line YYY

    • You must check this data conformity on the file (sensitive case, expected entry). See enumarated values Lens Appearance Label

  • [Warning]: The value XXX is not correct for the specific data Supplier SKU Status at line YYY

    • You must check this data conformity on the file (sensitive case, expected entry). See enumarated values Supplier SKU Status

  • [Error]: Global Master Code already exists on the file at line YYY

    • This code must be unique

  • [Warning]: La valeur XXX n'est pas correcte pour la donnée spécifique Base Lens à la ligne YYY

  • [Warning]: La valeur XXX n'est pas correcte pour la donnée spécifique Coating Color à la ligne YYY

    • The defined value doesn’t exist on the list of possibilities. See your specific enumarated values.

  • No labels

© 2018 iZySolutions