{"id":562,"date":"2024-01-01T19:41:33","date_gmt":"2024-01-01T16:41:33","guid":{"rendered":"http:\/\/themes.thememasters.club\/alzerp\/?post_type=product&p=562"},"modified":"2025-05-30T00:47:48","modified_gmt":"2025-05-29T21:47:48","slug":"excel-data-import","status":"publish","type":"product","link":"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/","title":{"rendered":"Data Import Service"},"content":{"rendered":"

To bring data from various external systems and databases into your ALZERP account. This process eliminates manual data entry, improving accuracy and efficiency. To Import data into ALZERP software from your existing data below are the fields available in ALZERP:<\/p>\n

    \n
  1. Products List:<\/strong><\/li>\n<\/ol>\n
    \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    SL<\/th>\nCOLUMN_NAME<\/th>\nDATA_TYPE<\/th>\nIS_NULLABLE<\/th>\nMAX_LENGTH<\/th>\nDEFAULT<\/th>\n<\/tr>\n
    1<\/td>\nProductID<\/td>\nint<\/td>\nNO<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    2<\/td>\nBarcode<\/td>\nvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    3<\/td>\nBarcodeImage<\/td>\nimage<\/td>\nYES<\/td>\n2147483647<\/td>\n<\/td>\n<\/tr>\n
    4<\/td>\nBarcode1<\/td>\nvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    5<\/td>\nIsAutoCode<\/td>\nbit<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    6<\/td>\nName<\/td>\nnvarchar<\/td>\nNO<\/td>\n500<\/td>\n<\/td>\n<\/tr>\n
    7<\/td>\nLocalName<\/td>\nnvarchar<\/td>\nYES<\/td>\n500<\/td>\n<\/td>\n<\/tr>\n
    8<\/td>\nUnitID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    9<\/td>\nUnitPerCurton<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((1))<\/td>\n<\/tr>\n
    10<\/td>\nIsRetailUnit<\/td>\nbit<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    11<\/td>\nQuantityPerUnit<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((1))<\/td>\n<\/tr>\n
    12<\/td>\nRetailUnitID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    13<\/td>\nProductCategoryID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    14<\/td>\nProductSubCategoryID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    15<\/td>\nDescription<\/td>\nnvarchar<\/td>\nYES<\/td>\n500<\/td>\n<\/td>\n<\/tr>\n
    16<\/td>\nStockBookID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    17<\/td>\nMinStockQty<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    18<\/td>\nMinOrderQTy<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    19<\/td>\nUnitPurchaseCost<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    20<\/td>\nUnitPrice<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    21<\/td>\nWholesalePrice<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    22<\/td>\nSRSalePrice<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    23<\/td>\nSalePrice<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    24<\/td>\nRetailPrice<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    25<\/td>\nVATPercentage<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    26<\/td>\nVATAmount<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    27<\/td>\nDiscountPercentage<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    28<\/td>\nDiscountAmount<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    29<\/td>\nNetPrice<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    30<\/td>\nMinimumSalePrice<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

    2. Employee List:<\/strong><\/p>\n

    \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    SL<\/th>\nCOLUMN_NAME<\/th>\nDATA_TYPE<\/th>\nIS_NULLABLE<\/th>\nMAX_LENGTH<\/th>\nDEFAULT<\/th>\n<\/tr>\n
    1<\/td>\nEmployeeID<\/td>\nint<\/td>\nNO<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    2<\/td>\nProjectId<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    3<\/td>\nBranchId<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    4<\/td>\nEmpId<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    5<\/td>\nName<\/td>\nnvarchar<\/td>\nYES<\/td>\n500<\/td>\n<\/td>\n<\/tr>\n
    6<\/td>\nDesignationID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    7<\/td>\nGender<\/td>\nvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    8<\/td>\nBloodGroup<\/td>\nvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    9<\/td>\nMaterialStatus<\/td>\nvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    10<\/td>\nMobile<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    11<\/td>\nTelephoneOffice<\/td>\nnvarchar<\/td>\nYES<\/td>\n20<\/td>\n<\/td>\n<\/tr>\n
    12<\/td>\nEmail<\/td>\nvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    13<\/td>\nEduQualificationID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    14<\/td>\nDOB<\/td>\ndatetime<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    15<\/td>\nFatherName<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    16<\/td>\nSalary<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    17<\/td>\nBuildingNumber<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    18<\/td>\nStreetName<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    19<\/td>\nDistrictName<\/td>\nnvarchar<\/td>\nYES<\/td>\n250<\/td>\n<\/td>\n<\/tr>\n
    20<\/td>\nCityName<\/td>\nnvarchar<\/td>\nYES<\/td>\n250<\/td>\n<\/td>\n<\/tr>\n
    21<\/td>\nCountry<\/td>\nnvarchar<\/td>\nYES<\/td>\n100<\/td>\n<\/td>\n<\/tr>\n
    22<\/td>\nPostalCode<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    23<\/td>\nAdditionalNumber<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    24<\/td>\nVATNumber<\/td>\nnchar<\/td>\nYES<\/td>\n30<\/td>\n<\/td>\n<\/tr>\n
    25<\/td>\nNID<\/td>\nnchar<\/td>\nYES<\/td>\n30<\/td>\n<\/td>\n<\/tr>\n
    26<\/td>\nReligion<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    27<\/td>\nPresentAddress<\/td>\nnvarchar<\/td>\nYES<\/td>\n-1<\/td>\n<\/td>\n<\/tr>\n
    28<\/td>\nPermanentAddress<\/td>\nnvarchar<\/td>\nYES<\/td>\n-1<\/td>\n<\/td>\n<\/tr>\n
    29<\/td>\nDateOfJoining<\/td>\ndatetime<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    30<\/td>\nLocationID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    31<\/td>\nCenterID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    32<\/td>\nDepartmentSectionID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    33<\/td>\nAreaLocationID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    34<\/td>\nOfficeID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    35<\/td>\nStoreID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    36<\/td>\nPhotoID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    37<\/td>\nSignatureID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

    \n

    3. Parties List (Customers, Suppliers, Vendors, Clearing Agents)<\/strong><\/p>\n

    \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    SL<\/th>\nCOLUMN_NAME<\/th>\nDATA_TYPE<\/th>\nIS_NULLABLE<\/th>\nMAX_LENGTH<\/th>\nDEFAULT<\/th>\n<\/tr>\n
    1<\/td>\nPartyId<\/td>\nint<\/td>\nNO<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    2<\/td>\nName<\/td>\nnvarchar<\/td>\nYES<\/td>\n1000<\/td>\n<\/td>\n<\/tr>\n
    3<\/td>\nEmail<\/td>\nnvarchar<\/td>\nYES<\/td>\n1000<\/td>\n<\/td>\n<\/tr>\n
    4<\/td>\nContactPerson<\/td>\nnvarchar<\/td>\nYES<\/td>\n250<\/td>\n<\/td>\n<\/tr>\n
    5<\/td>\nContactNumber<\/td>\nnvarchar<\/td>\nYES<\/td>\n250<\/td>\n<\/td>\n<\/tr>\n
    6<\/td>\nIsTaxExempt<\/td>\nbit<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    7<\/td>\nBuildingNumber<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    8<\/td>\nStreetName<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    9<\/td>\nDistrictName<\/td>\nnvarchar<\/td>\nYES<\/td>\n250<\/td>\n<\/td>\n<\/tr>\n
    10<\/td>\nCityName<\/td>\nnvarchar<\/td>\nYES<\/td>\n250<\/td>\n<\/td>\n<\/tr>\n
    11<\/td>\nCountry<\/td>\nnvarchar<\/td>\nYES<\/td>\n100<\/td>\n<\/td>\n<\/tr>\n
    12<\/td>\nPostalCode<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    13<\/td>\nAdditionalNumber<\/td>\nnvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    14<\/td>\nVATNumber<\/td>\nvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    15<\/td>\nTINNumber<\/td>\nvarchar<\/td>\nYES<\/td>\n50<\/td>\n<\/td>\n<\/tr>\n
    16<\/td>\nLocationId<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    17<\/td>\nAreaId<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    18<\/td>\nStoreAssignId<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    19<\/td>\nPartyRoleId<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    20<\/td>\nActive<\/td>\nbit<\/td>\nYES<\/td>\n<\/td>\n((1))<\/td>\n<\/tr>\n
    21<\/td>\nDr<\/td>\nbit<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    22<\/td>\nCr<\/td>\nbit<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    23<\/td>\nAddress<\/td>\nnvarchar<\/td>\nYES<\/td>\n-1<\/td>\n<\/td>\n<\/tr>\n
    24<\/td>\nOpeningBalanceDate<\/td>\ndatetime<\/td>\nYES<\/td>\n<\/td>\n(((2023)-(12))-(31))<\/td>\n<\/tr>\n
    25<\/td>\nOpeningBalance<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    26<\/td>\nOBActual<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    27<\/td>\nDescription<\/td>\nnvarchar<\/td>\nYES<\/td>\n-1<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

    \n

    4. Opening Stock Position<\/strong><\/p>\n

    \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    SL<\/th>\nCOLUMN_NAME<\/th>\nDATA_TYPE<\/th>\nIS_NULLABLE<\/th>\nMAX_LENGTH<\/th>\nDEFAULT<\/th>\n<\/tr>\n
    1<\/td>\nStockID<\/td>\nint<\/td>\nNO<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    2<\/td>\nEntryDate<\/td>\ndatetime2<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    3<\/td>\nEntryType<\/td>\nnvarchar<\/td>\nYES<\/td>\n100<\/td>\n<\/td>\n<\/tr>\n
    4<\/td>\nEntryTypeId<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    5<\/td>\nRetailUnitID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    6<\/td>\nProductCategoryID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    7<\/td>\nProductSubCategoryID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    8<\/td>\nProductID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    9<\/td>\nPartyID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    10<\/td>\nDescription<\/td>\nnvarchar<\/td>\nYES<\/td>\n-1<\/td>\n<\/td>\n<\/tr>\n
    11<\/td>\nBranchID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    12<\/td>\nStoreID<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    13<\/td>\nUnitPrice<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    14<\/td>\nInQuantity<\/td>\ndecimal<\/td>\nNO<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    15<\/td>\nInVATPercentage<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    16<\/td>\nInVATAmount<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    17<\/td>\nOutQuantity<\/td>\ndecimal<\/td>\nNO<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    18<\/td>\nOutVATPercentage<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    19<\/td>\nOutVATAmount<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    20<\/td>\nFifoFractionIn<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    21<\/td>\nFifoFractionOut<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    22<\/td>\nTotalAmount<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    23<\/td>\nRemark<\/td>\nnvarchar<\/td>\nYES<\/td>\n-1<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

    \n

    5. Chart of Accounts for Initial Trial Balance:<\/strong><\/p>\n

    \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    SL<\/th>\nCOLUMN_NAME<\/th>\nDATA_TYPE<\/th>\nIS_NULLABLE<\/th>\nMAX_LENGTH<\/th>\nDEFAULT<\/th>\n<\/tr>\n
    1<\/td>\nEntryID<\/td>\nint<\/td>\nNO<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    2<\/td>\nGroupID<\/td>\nvarchar<\/td>\nYES<\/td>\n2<\/td>\n<\/td>\n<\/tr>\n
    3<\/td>\nAccountsID<\/td>\nvarchar<\/td>\nYES<\/td>\n4<\/td>\n<\/td>\n<\/tr>\n
    4<\/td>\nControlAccountsID<\/td>\nvarchar<\/td>\nYES<\/td>\n6<\/td>\n<\/td>\n<\/tr>\n
    5<\/td>\nAccountsHeadID<\/td>\nvarchar<\/td>\nNO<\/td>\n10<\/td>\n<\/td>\n<\/tr>\n
    6<\/td>\nAccountsHeadName<\/td>\nnvarchar<\/td>\nNO<\/td>\n900<\/td>\n<\/td>\n<\/tr>\n
    7<\/td>\nOpBalDr<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    8<\/td>\nOpBalCr<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    <\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    <\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    <\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    <\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    <\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    14<\/td>\nAccountsOpeningBalance<\/td>\ndecimal<\/td>\nYES<\/td>\n<\/td>\n((0))<\/td>\n<\/tr>\n
    15<\/td>\nOpDate<\/td>\ndatetime<\/td>\nYES<\/td>\n<\/td>\n(getdate())<\/td>\n<\/tr>\n
    16<\/td>\nServerDateTime<\/td>\ndatetime<\/td>\nYES<\/td>\n<\/td>\n(getdate())<\/td>\n<\/tr>\n
    17<\/td>\nEmark<\/td>\nvarchar<\/td>\nYES<\/td>\n50<\/td>\n(‘U’)<\/td>\n<\/tr>\n
    18<\/td>\nIsActive<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n((1))<\/td>\n<\/tr>\n
    19<\/td>\nVATable<\/td>\nbit<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    20<\/td>\nExpenseStoreId<\/td>\nint<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    21<\/td>\nProjectID<\/td>\nvarchar<\/td>\nYES<\/td>\n50<\/td>\n((1))<\/td>\n<\/tr>\n
    22<\/td>\nBranchId<\/td>\nvarchar<\/td>\nYES<\/td>\n50<\/td>\n((0))<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

    \n

    Here’s a breakdown of key aspects of our Data Import Services:<\/p>\n

      \n
    • \n

      Data Source Flexibility:<\/strong> It enables you to import data from a variety of sources, including:<\/p>\n

        \n
      • Flat files:<\/strong> Comma-Separated Values (CSV), Excel spreadsheets, Text files.<\/li>\n
      • Databases:<\/strong> Connect to external databases like MySQL, SQL Server, Oracle, etc.<\/li>\n
      • Cloud Applications:<\/strong> Import data from CRM systems, accounting software, or other cloud-based applications your business uses.<\/li>\n<\/ul>\n<\/li>\n
      • \n

        Mapping and Transformation:<\/strong> The import service typically provides tools for mapping the data from the external source to the corresponding fields within your ALZERP account. This ensures accurate data integration and avoids inconsistencies.<\/p>\n

          \n
        • You might need to define how data points from the external source translate to the appropriate fields in your ERP system (e.g., matching customer names, product codes, etc.).<\/li>\n
        • To manipulate or clean the data before import (e.g., removing duplicates, and formatting dates).<\/li>\n<\/ul>\n<\/li>\n
        • \n

          Import Modes:<\/strong><\/p>\n

            \n
          • Initial Load:<\/strong> Used to populate your ALZERP account with data for the first time.<\/li>\n
          • Incremental Updates:<\/strong> Allows for regular updates of specific data sets from external sources, ensuring your ERP system reflects the latest information.<\/li>\n<\/ul>\n<\/li>\n
          • \n

            Benefits of Using ERP Data Import Services:<\/strong><\/p>\n

              \n
            • Reduced Manual Data Entry:<\/strong> Eliminates the risk of errors and saves time for your employees.<\/li>\n
            • Improved Data Accuracy:<\/strong> Ensures consistency and accuracy across your entire ERP system.<\/li>\n
            • Enhanced Efficiency:<\/strong> Streamlines data management processes and reduces the workload on your IT team.<\/li>\n
            • Faster Time to Insights:<\/strong> This enables you to leverage all your data in one place for better reporting and data analysis.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

               <\/p>\n

                \n
              • Before purchasing this service:<\/strong>\n
                  \n
                • Please prepare all your data in an Excel File (ie, Details of Products with prices, Parties with balances etc.)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                  To bring data from various external systems and databases into your ALZERP account. This process eliminates the need for manual data entry, improving accuracy and efficiency.<\/p>\n","protected":false},"featured_media":638,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[38],"product_tag":[153],"class_list":{"0":"post-562","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-alzerp-add-ons","7":"product_tag-data-import","9":"first","10":"instock","11":"virtual","12":"purchasable","13":"product-type-simple"},"yoast_head":"\r\nData Import Service - ALZERP Knowledgebase<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Data Import Service - ALZERP Knowledgebase\" \/>\r\n<meta property=\"og:description\" content=\"To bring data from various external systems and databases into your ALZERP account. This process eliminates the need for manual data entry, improving accuracy and efficiency.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ALZERP Knowledgebase\" \/>\r\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/alzclouderp\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-05-29T21:47:48+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.alzerp.com\/kb\/wp-content\/uploads\/2024\/01\/Alz-Logo-black-2x.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"1249\" \/>\r\n\t<meta property=\"og:image:height\" content=\"1249\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:site\" content=\"@alwajeeztech\" \/>\r\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/\",\"url\":\"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/\",\"name\":\"Data Import Service - ALZERP Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/www.alzerp.com\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.alzerp.com\/kb\/wp-content\/uploads\/2024\/01\/Alz-Logo-black-2x.png\",\"datePublished\":\"2024-01-01T16:41:33+00:00\",\"dateModified\":\"2025-05-29T21:47:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/#primaryimage\",\"url\":\"https:\/\/www.alzerp.com\/kb\/wp-content\/uploads\/2024\/01\/Alz-Logo-black-2x.png\",\"contentUrl\":\"https:\/\/www.alzerp.com\/kb\/wp-content\/uploads\/2024\/01\/Alz-Logo-black-2x.png\",\"width\":1249,\"height\":1249,\"caption\":\"Business management software , ERP software , Accounting software , Inventory management software , Small business software , Point-of-sale (POS) software , Business accounting software , Inventory control software , Order management software , Purchase order software , Stock control software , cloud ERP , cloud ERP software , cloud ERP solutions , ERP SaaS , cloud-based ERP , ERP solutions , Cloud software , Enterprise resource planning system , ERP accounting software , ERP management software , ERP software , ERP system , ERP solution providers , distribution ERP software , ERP software solutions , Online ERP software , Online ERP system , Online erp , ERP software providers , Enterprise business software\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.alzerp.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Shop\",\"item\":\"https:\/\/www.alzerp.com\/kb\/shop\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data Import Service\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.alzerp.com\/kb\/#website\",\"url\":\"https:\/\/www.alzerp.com\/kb\/\",\"name\":\"ALZERP Cloud ERP Software\",\"description\":\"Ready ERP for Wholesale & Retail Business\",\"publisher\":{\"@id\":\"https:\/\/www.alzerp.com\/kb\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.alzerp.com\/kb\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.alzerp.com\/kb\/#organization\",\"name\":\"Alwajeez Tech\",\"url\":\"https:\/\/www.alzerp.com\/kb\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.alzerp.com\/kb\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.alzerp.com\/kb\/wp-content\/uploads\/2024\/06\/logo_sq.png\",\"contentUrl\":\"https:\/\/www.alzerp.com\/kb\/wp-content\/uploads\/2024\/06\/logo_sq.png\",\"width\":752,\"height\":719,\"caption\":\"Alwajeez Tech\"},\"image\":{\"@id\":\"https:\/\/www.alzerp.com\/kb\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/alzclouderp\",\"https:\/\/x.com\/alwajeeztech\",\"https:\/\/www.linkedin.com\/company\/alwajeez-tech\"]}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Import Service - ALZERP Knowledgebase","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/","og_locale":"en_US","og_type":"article","og_title":"Data Import Service - ALZERP Knowledgebase","og_description":"To bring data from various external systems and databases into your ALZERP account. This process eliminates the need for manual data entry, improving accuracy and efficiency.","og_url":"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/","og_site_name":"ALZERP Knowledgebase","article_publisher":"https:\/\/www.facebook.com\/alzclouderp","article_modified_time":"2025-05-29T21:47:48+00:00","og_image":[{"width":1249,"height":1249,"url":"https:\/\/www.alzerp.com\/kb\/wp-content\/uploads\/2024\/01\/Alz-Logo-black-2x.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@alwajeeztech","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/","url":"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/","name":"Data Import Service - ALZERP Knowledgebase","isPartOf":{"@id":"https:\/\/www.alzerp.com\/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/#primaryimage"},"image":{"@id":"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/#primaryimage"},"thumbnailUrl":"https:\/\/www.alzerp.com\/kb\/wp-content\/uploads\/2024\/01\/Alz-Logo-black-2x.png","datePublished":"2024-01-01T16:41:33+00:00","dateModified":"2025-05-29T21:47:48+00:00","breadcrumb":{"@id":"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/#primaryimage","url":"https:\/\/www.alzerp.com\/kb\/wp-content\/uploads\/2024\/01\/Alz-Logo-black-2x.png","contentUrl":"https:\/\/www.alzerp.com\/kb\/wp-content\/uploads\/2024\/01\/Alz-Logo-black-2x.png","width":1249,"height":1249,"caption":"Business management software , ERP software , Accounting software , Inventory management software , Small business software , Point-of-sale (POS) software , Business accounting software , Inventory control software , Order management software , Purchase order software , Stock control software , cloud ERP , cloud ERP software , cloud ERP solutions , ERP SaaS , cloud-based ERP , ERP solutions , Cloud software , Enterprise resource planning system , ERP accounting software , ERP management software , ERP software , ERP system , ERP solution providers , distribution ERP software , ERP software solutions , Online ERP software , Online ERP system , Online erp , ERP software providers , Enterprise business software"},{"@type":"BreadcrumbList","@id":"https:\/\/www.alzerp.com\/kb\/product\/excel-data-import\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.alzerp.com\/kb\/"},{"@type":"ListItem","position":2,"name":"Shop","item":"https:\/\/www.alzerp.com\/kb\/shop\/"},{"@type":"ListItem","position":3,"name":"Data Import Service"}]},{"@type":"WebSite","@id":"https:\/\/www.alzerp.com\/kb\/#website","url":"https:\/\/www.alzerp.com\/kb\/","name":"ALZERP Cloud ERP Software","description":"Ready ERP for Wholesale & Retail Business","publisher":{"@id":"https:\/\/www.alzerp.com\/kb\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.alzerp.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.alzerp.com\/kb\/#organization","name":"Alwajeez Tech","url":"https:\/\/www.alzerp.com\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.alzerp.com\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.alzerp.com\/kb\/wp-content\/uploads\/2024\/06\/logo_sq.png","contentUrl":"https:\/\/www.alzerp.com\/kb\/wp-content\/uploads\/2024\/06\/logo_sq.png","width":752,"height":719,"caption":"Alwajeez Tech"},"image":{"@id":"https:\/\/www.alzerp.com\/kb\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/alzclouderp","https:\/\/x.com\/alwajeeztech","https:\/\/www.linkedin.com\/company\/alwajeez-tech"]}]}},"_links":{"self":[{"href":"https:\/\/www.alzerp.com\/kb\/wp-json\/wp\/v2\/product\/562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alzerp.com\/kb\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.alzerp.com\/kb\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alzerp.com\/kb\/wp-json\/wp\/v2\/comments?post=562"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.alzerp.com\/kb\/wp-json\/wp\/v2\/media\/638"}],"wp:attachment":[{"href":"https:\/\/www.alzerp.com\/kb\/wp-json\/wp\/v2\/media?parent=562"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.alzerp.com\/kb\/wp-json\/wp\/v2\/product_brand?post=562"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.alzerp.com\/kb\/wp-json\/wp\/v2\/product_cat?post=562"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.alzerp.com\/kb\/wp-json\/wp\/v2\/product_tag?post=562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}