Preparing Excel File

Video Tutorial : #

Analyze and test the issues of product import (excel file) from which you want the data to be import in All Import tool.

STEP # 01 #

Check the duplication in SKU-CODE column and if any duplications are found removed them.

Steps to removed duplications in excel:

  1. Select a column and click on Conditional Formatting on the HOME
  2. Under Conditional Formatting menu hover over Highlight Cells Rules and click on duplicate values.
  3. Click ok button and check for duplications in the file.

STEP # 2 #

  1. Test Type column and if it is a variable product check that child SKU is correct or not.

2. In the above image see that TYPE column have variations for every parent product. As the system does not have any variation field for mapping, these all variations will be replaced by variable as shown in the image below.

STEP # 3 #

Check the Outlet ID and set it correctly if it is showing different outlets for different products. The outlet should be same otherwise the stocks will not be map in the outlet.

STEP # 4 #

  1. The final step is to test the Function Outlet Stock and check that the formula is correctly applied on this column.
  2. The columns to be merged are in the sequence (T->U->V->P->W) preceding with the equal to sign.

STEP # 5 #

Our Product Import Excel File is now ready to import. Navigate to the next section for importing file.

Leave a Comment

Schedule your meeting
with team IMPAKTT today!

Our team will get in touch with meating details and schedule within 48 hours.

GET STARTED

0$

Glad To Assist You..!.
Thank you for your interest, we have received your request. One of our experts will be in touch with you soon to transform your business profitability.

Close

IMPAKTT Team Is Passionately Helpful To Redefine Your Business Profitability.

Feel comfortable! We care about your privacy.



    You need to select an item to continue

    NEXT STEP

    Specify Your Main Business Industry

    eCommerce

    Retail

    Manufacturing

    Services

    Others

    You need to select an item to continue

    NEXT STEP

    Please specify your product type?

    Clothing

    Electronics

    Furniture

    Blinds

    Toys

    Grocery

    Home Decoration

    Building Materials

    Multiple Types

    You need to select an item to continue

    NEXT STEP

    Do You Sell Online?


    You need to select an item to continue

    NEXT STEP

    Select From IMPAKTT Amazing Sales Solutions?

    Online Shop

    Ordering Management

    CRM

    B2B Deals Management

    You need to select an item to continue

    NEXT STEP

    Automate Your Operations, You’re on your way to being more profitable!

    Logistics Management

    Inventory Management

    Finance Management

    Support Management

    Project Management

    You need to select an item to continue

    NEXT STEP

    Optimize Productivity by Empowering Each Team Member?

    HRM

    Asset

    Payroll

    Reimbursement

    You need to select an item to continue

    NEXT STEP

    Boost Your Revenue By Robust Tools?

    Analytics

    eVoucher & Coupon Management

    Loyalty Points Management

    Referral Management

    Security Compliance

    Digital Campaign Management

    You need to select an item to continue

    NEXT STEP

    Specify Your Main Business Industry (1)

    eCommerce

    Retail

    Manufacturing

    Services

    Others

    You need to select an item to continue

    NEXT STEP

    Please specify your product type? (1)

    Clothing

    Electronics

    Furniture

    Blinds

    Toys

    Grocery

    Home Decoration

    Building Materials

    Multiple Types

    You need to select an item to continue

    NEXT STEP

    Do You Sell Online? (1)


    You need to select an item to continue

    NEXT STEP

    Your eCommerce Built On? (1)

    WooCommerce

    Magento

    Shopify

    Don’t Know

    You need to select an item to continue

    NEXT STEP

    We Recommend You to Grow You, Do You Prefer eCommerce Store? (1)

    You need to select an item to continue

    NEXT STEP

    Retail (1)

    We love to hear more about your Business, please specify?

    Purchase & Retail

    Retail & B2B Distribution


    You need to select an item to continue

    NEXT STEP

    Manufacturing (1)

    Please specify how you sell your produced inventory?

    B2B Distribution

    Retail & B2B Distribution



    You need to select an item to continue

    NEXT STEP

    Other

    We love to hear more about your Business ?

    You need to select an item to continue

    NEXT STEP

    Your Identity Will Help Us to Keep You Unique (1)

    You need to select an item to continue

    NEXT STEP

    We Shall Contact You If Needed (1)

    You need to select an item to continue

    NEXT STEP

    Sit Relax, Our Helpful Care Team Will Contact You Sooner!

    You need to select an item to continue

    NEXT STEP

    Retail

    We love to hear more about your Business, please specify?

    Purchase & Retail

    Retail & B2B Distribution


    You need to select an item to continue

    NEXT STEP

    Please specify your product type? (R)

    Clothing

    Electronics

    Furniture

    Blinds

    Toys

    Grocery

    Home Decoration

    Building Materials

    Multiple Types

    You need to select an item to continue

    NEXT STEP

    Manufacturing

    Please specify how you sell your produced inventory?

    B2B Distribution

    Retail & B2B Distribution



    You need to select an item to continue

    NEXT STEP

    Other (O)

    We love to hear more about your Business ?

    You need to select an item to continue

    NEXT STEP

    Please specify your product type? (M)

    Clothing

    Electronics

    Furniture

    Blinds

    Toys

    Grocery

    Home Decoration

    Building Materials

    Multiple Types

    You need to select an item to continue

    NEXT STEP

    Do You Sell Online? (S)


    You need to select an item to continue

    NEXT STEP

    Do You Sell Online? (R)


    You need to select an item to continue

    NEXT STEP

    Your eCommerce Built On? (R)

    We Recommend You to Grow You, Do You Prefer eCommerce Store?

    WooCommerce

    Magento

    Shopify

    Don’t Know




    You need to select an item to continue

    NEXT STEP

    Do You Sell Online? (M)


    You need to select an item to continue

    NEXT STEP

    Your eCommerce Built On? (M)

    We Recommend You to Grow You, Do You Prefer eCommerce Store?

    WooCommerce

    Magento

    Shopify

    Don’t Know




    You need to select an item to continue

    NEXT STEP

    Your eCommerce Built On? (S)

    We Recommend You to Grow You, Do You Prefer eCommerce Store?

    WooCommerce

    Magento

    Shopify

    Don’t Know




    You need to select an item to continue

    NEXT STEP

    Select From IMPAKTT Amazing Sales Solutions? (R)

    Online Shop

    Point Of Sale

    CRM

    Order Management

    B2B Deals Management

    You need to select an item to continue

    NEXT STEP

    Select From IMPAKTT Amazing Sales Solutions? (M)

    B2B Deals Management

    Online Shop

    Point Of Sale

    CRM

    You need to select an item to continue

    NEXT STEP

    Select From IMPAKTT Amazing Sales Solutions? (S)

    Online Shop

    Point Of Sale

    CRM

    Order Management

    B2B Deals Management

    You need to select an item to continue

    NEXT STEP

    Automate Your Operations, You’re on your way to being more profitable!

    Logistics Management

    Inventory Management

    Finance Management

    Support Management

    Project Management

    You need to select an item to continue

    NEXT STEP

    Optimize Productivity by Empowering Each Team Member? (S)

    HRM

    Asset Management

    Payroll

    Reimbursement

    You need to select an item to continue

    NEXT STEP

    Boost Your Revenue By Robust Tools? (S)

    Analytics

    eVoucher & Coupon Management

    Loyalty Points Management

    Referral Management

    Security Compliance

    Digital Campaign Management

    You need to select an item to continue

    NEXT STEP

    Automate Your Operations, You’re on your way to being more profitable! (M)

    Logistics Management

    Inventory Management

    Finance Management

    Support Management

    Project Management

    You need to select an item to continue

    NEXT STEP

    Optimize Productivity by Empowering Each Team Member? (M)

    HRM

    Asset Management

    Payroll

    Reimbursement

    You need to select an item to continue

    NEXT STEP

    Boost Your Revenue By Robust Tools? (M)

    Analytics

    eVoucher & Coupon Management

    Loyalty Points Management

    Referral Management

    Security Compliance

    Digital Campaign Management

    You need to select an item to continue

    NEXT STEP

    Automate Your Operations, You’re on your way to being more profitable! (R)

    Logistics Management

    Inventory Management

    Finance Management

    Support Management

    Project Management

    You need to select an item to continue

    NEXT STEP

    Optimize Productivity by Empowering Each Team Member? (R)

    HRM

    Asset Management

    Payroll

    Reimbursement

    You need to select an item to continue

    NEXT STEP

    Boost Your Revenue By Robust Tools? (R)

    Analytics

    eVoucher & Coupon Management

    Loyalty Points Management

    Referral Management

    Security Compliance

    Digital Campaign Management

    You need to select an item to continue

    NEXT STEP

    Do You Sell Online? (O)


    You need to select an item to continue

    NEXT STEP

    Your eCommerce Built On? (O)

    We Recommend You to Grow You, Do You Prefer eCommerce Store?

    WooCommerce

    Magento

    Shopify

    Don’t Know




    You need to select an item to continue

    NEXT STEP

    Automate Your Operations, You’re on your way to being more profitable!(O)

    Logistics Management

    Inventory Management

    Finance Management

    Support Management

    Project Management

    You need to select an item to continue

    NEXT STEP

    Boost Your Revenue By Robust Tools? (O)

    Analytics

    eVoucher & Coupon Management

    Loyalty Points Management

    Referral Management

    Security Compliance

    Digital Campaign Management

    You need to select an item to continue

    NEXT STEP

    Select From IMPAKTT Amazing Sales Solutions? (O)

    Online Shop

    Point Of Sale

    CRM

    Order Management

    B2B Deals Management

    You need to select an item to continue

    NEXT STEP

    Your eCommerce Built On?

    We Recommend You to Grow You, Do You Prefer eCommerce Store?

    WooCommerce

    Magento

    Shopify

    Don’t Know




    You need to select an item to continue

    NEXT STEP

    eCommerce

    Great! Globally growing Industry, pick your business.

    Online Store

    Suppliers Marketplace

    E-Mall (Seller Marketplace)

    You need to select an item to continue

    NEXT STEP

    eCommerce (1)

    Great! Globally growing Industry, pick your business.

    Online Store

    Suppliers Marketplace

    E-Mall (Seller Marketplace)

    You need to select an item to continue

    NEXT STEP

    Services (1)

    We love to hear more about your Business, please specify?

    Digital Services

    Rental

    Construction

    Purchase & Installation

    Produce & Deploy

    You need to select an item to continue

    NEXT STEP

    Services

    We love to hear more about your Business, please specify?

    Digital Services

    Rental

    Construction

    Purchase & Installation

    Produce & Deploy

    You need to select an item to continue

    NEXT STEP

    Sit Relax, Our Helpful Care Team Will Update You Sooner!

    Summary

    Description Information Quantity Price
    Discount :
    Total :

    Submit