1 thought on “Suppliers Info !”

  1. How to upload Variant Products on MeriApp template

    Step 1:-

    Open template and the in the Column “A” (ID) Enter number like 1,2,3,4,5,6 According to rows

    Step 2:-

    Column “B” (Type) If you product consist of variants type “variable” in parent row and “varaition” in variants row

    Step 3:-

    Column “C” (SKU) enter sku id of product in parent category like vo001 (write sku with variant name like vo001S, vo001M, vo001L, vo001XL)

    Step 4:-

    Column “D” (Name) enter the name of the product ( the name should be enter in variations also )

    Step 5:-

    Column “E” (Published) enter “1” (1 means yes) in variants also

    Step 6:-

    Column “F” (Is featured?) enter “1” (1 means yes) in variants also

    Step 7:-

    Column “G” (Visibility in catalog) type “visible” in variants also

    Step 8:-

    Column “H” (Short description) leave it blank

    Step 9:-

    Column “I” (Description) enter your product description in variants also (Fabric story, size, lengh , size, etc) “don’t include rate” in html format starting with “<"pre">” and end with “<"/pre">”

    Note :- Leave blank “J & K” Column (Date sale price starts, Date sale price ends)

    Step 10:-

    Column “L” (Tax status) type “taxable”

    Step 11:-

    Column “M” (Tax class) write “gst-5” and in variants write “parent”

    Step 12:-

    Column “N” (In stock?) type “1” same in variation

    Step 13:-

    Column “O” (Stock) enter the quantity of the product only in variation (don’t write stock quantity in variable column”parent”)

    Note:- Leave Blank “P, Q & R” column (Low stock amount, Backorders allowed?, Sold individually?) or you can write “0”

    Step 14:-

    Column “S” (Weight (kg)) write “.499” default and if you know the acctual weight you can write only in variable row (parent)

    Note:- Leave Blank “T,U & V” (Length (cm), Width (cm), Height (cm)) and if you know you can write only in variable row (parent)

    Step 15:-

    Column “W” (Allow customer reviews?) type “1” so the customers can give your product reviews only in variable row (parent)

    Note:- Leave Blank “X” (Purchase note)

    Step 16:-

    Column “Y” (Sale price) enter your “transfer price” which you give to meriapp not customers otherwise your template will not be published (only in “variation” (not in variable “parent”))

    Step 17:-

    Column”Z” (Regular price) enter fake price (the fake price should be higher then sale price) to gat a sale tag on your product (only in “variation” (not in variable “parent”))

    Step 18:-

    Column “AA” (Categories) enter product category in this format = if cotton saree (saree > cotton saree), if cotton suit (Suit > Cotton suit) only in variable row “Parent”

    Step 19:-

    Column “AB” (Tags) enter product tag seprated with commas (,) by which customer can search your product easily, if cotton suit (suit, cotton, cotton suit, latest, trendy)
    only in variable row “Parent”

    Step 20:-

    Column “AC” (Shipping class) enter “Free Shipping” always only in variable row “Parent”

    Step 21:-

    Column “AD” (Images) enter product image link and if the single product have more images enter link seprated with commas “,”(link, link, link, etc)
    Note:- If you don’t know how to make image link then follow the steps:-
    1). Open imgbb.com
    2). Click on Start Uploading
    3). Choose a product image you want to conver into link
    4). Click on convert
    5). After getting link Copy it and past it on (Images) Column

    Note:- Leave Blank “AE, AF, AG, AH, AI, AJ, AK & AL” (Download limit, Download expiry days, Parent, Grouped products, Upsells, Cross-sells, External URL & Button text)

    Step 22:-

    Column “AM” (Position) enter “0” in Variable “parent” and “1, 2, 3, 4 according to “variants” in variation row

    Step 23:-

    Column “BD” (Attribute 1 name) Variant name ” Size, Color, etc”

    Step 24:-

    Column “BE” (Attribute 1 value(s)) Variant value “S, M, L, XL, etc” if size or ” Pink, Grey, Black” if color

    Step 25:-

    Column “BF” (Attribute 1 visible) write “1”

    Step 26:-

    Column “BG” (Attribute 1 global) write “1”

    Step 27:-

    Column “BH” (Attribute 2 name) Variant name ” Size, Color, etc”

    Step 28:-

    Column “BI” (Attribute 2 value(s)) Variant value “S, M, L, XL, etc” if size or ” Pink, Grey, Black” if color

    Step 29:-

    Column “BJ” (Attribute 2 visible) write “1”

    Step 30:-

    Column “BK” (Attribute 2 global) write “1”

    and after it save it and send to :- [email protected]
    For any issue contact us on :- 8003435466

Leave a Comment