Skip to content Skip to sidebar Skip to footer
Home / How to Upload Products in Bulk in Joomla

How to Upload Products in Bulk in Joomla

Post a Comment

This amazing extension can easily import/drift users from Excel/CSV file into Joomla and preinstalled "Contacts" component. Each imported user volition be created as a usual Joomla user, and so admin tin easily manage them in the admin panel and users get all benefits of registered accounts on your web-site!
Our import is user-friendly, piece of cake to use and doesn't require any special technical knowledge to use information technology.


User import extension supports wide range of fields:

  • Joomla cadre user fields: Id, Proper noun, Username, Password, Email, Params, Annals Date and Grouping(southward).
  • Predefined "Contacts" fields: Total Name, Epitome, Position, E-mail, Address, City or Suburb, State or Province, Postal/ZIP Lawmaking, Country, Phone, Mobile, Fax, Website, Description, Registered date.
  • Joomla Users Fields: Any custom fields created via Joomla iii.7+ Users Fields system, read more.

Main features of user import:

  • Creates only new users, update existing users or does both actions at once.
  • Specific columns order in file not required.
  • Allows you to import users into ane or a few Joomla groups.
  • Gives possibility to set new password for users (patently or already encrypted one).
  • If a file doesn't incorporate passwords, import can create passwords automatically.
  • Sends "Welcome" emails to imported users with login/pass and other info, read more.
  • "E-mail Sending Study" is available, and then you can check if emails were sent to users.
  • Allows y'all to shop import settings into "Profile" for regular import, read more.
  • Makes it possible to block users automatically which are no longer exist in Excel/CSV file.
  • Grants access to import extension to specific Joomla groups.
  • Imports multiple checkbox values.
  • Provides auto users import by schedule (using Cron).
  • Imports into "Improved AJAX Import & Register" extension fields.
  • Supports most of the third party components like "K2" or "AcyMailing".

Difference between "Contacts" fields and "Joomla Users Fields".

"Contacts" is a preinstalled Joomla component that allows you to shop additional information about a person and link it to a detail Joomla user.
To create new "Contact" navigate to: Admin console -> Components -> Contacts and press "New" push button. This component contains non-customizable predefined list of fields. However it allows you to create two or more Contacts per each user.

Our import extension supports "Contacts" component and can import data from excel/csv files into these fields. Our extension creates Joomla users first, then creates "Contacts" and links them to associated users.

Joomla User Fields supported past Joomla 3.7 and subsequently. These fields accept a huge advantage compared to "Contacts". Yous can add/remove/customize "Joomla Users Fields" as much every bit y'all need. The wide range of available fields include: text, dropdown, link, bank check box, radio box and much more. You can find these fields in Admin panel->Users->Fields:

On the screenshot you tin see that four fields accept been created, three regular text fields (Skype, Revenue enhancement Id and Position) and one dropdown field with car models. These fields are bachelor in the admin panel and in the user's business relationship on the website, so admin and user can read and change this data.

Determination: "Contacts" component is a good way to store additional information near the user. Y'all tin can store two or more Contacts per user. However it is not possible to create additional user fields that might be vital in some cases. If yous are looking for a style to store user data which is not predefined in "Contacts" then it is better to commencement with new "Joomla User Fields".

Import "Profiles" for regular use.

"Contour" is like a template with stored import settings. It was developed to salvage your time past setting up import settings once instead of doing this for each import.

Let'southward see how to set it up. For case, we've got a file with users from a third-party website and we need to create accounts for those users in our Joomla website. Since nosotros must update users every week - it'south better to use "Profiles" feature.

How to create "Profile":
1. Upload excel/CSV file.
two. Select Joomla group, match file'due south columns with user fields and specify other settings you lot may need.
3. Click on "SAVE PROFILE" push and requite "Profile" a proper noun. That's it, a new "Profile" has been created.

How to use "Profiles":
1. Get-go a new import. On step one y'all will see recently created profile. Click on upload button and select excel/CSV file.
ii. Click "Next" and on stride 2 all settings we've chosen before are already pulled up from "Profile" and automatically applied. And so nosotros but need to check if everything is okay and become to the adjacent step.

Hither is some useful cases when "Contour" characteristic comes in handy:
- file with users information has to be imported regularly, e.chiliad. each twenty-four hour period or week;
- you have two or more different excel/CSV files and each file has its own columns' order;
- yous demand to import all users from file #1 into e.g. "Managers" grouping and users from file #2 into "Editors" group.

That'south all you need to know to first saving fourth dimension now!

Sending emails to imported and/or updated users.

"Import Users" tool provides selection to notify new and/or existing users. With this pick you can send personalized letters along with users' data similar Proper name, Address, Password, etc.

In the example, we'll show how to set upward email sending to newly imported users. Since the user mailing is turned off by default, let'south enable it by the post-obit steps:

1. Go to 2nd step.

2. In "Email Settings" select "Notify..." options.

iii. Write e-mail message.

"Import Users" offers two types of variables:

  • "Default" – predefined variables listing that includes unremarkably used variables, like Name, Username, Website;
  • "Dynamic" – they pull values from imported file on the fly.


You can use "Default" & "Dynamic" variables in the "Email Template" popup. Both types of variables tin can be put into electronic mail "Subject" and email "Body". Using of "Default" variables is like shooting fish in a barrel, just place in editor listed variables similar %username% and it will be replaced with the existent username.

Data for "Dynamic" variables are taken from uploaded excel or csv file. And then, to use these variables it's required to have already matched columns to Joomla fields. For case if we match "Name", "Username", "Email", "Address", "Country" and "Postal code" on step 2 nosotros will be able to use these variable in Email Template popup.

Then click at "Add Fields" button and nosotros'll see dynamic variables of matched columns. To insert any of the above variables, just click on it. If list of variables is empty, that means that columns from the file oasis't been matched with Joomla fields, so match the columns first.

In case y'all want to use custom text colors, insert images or change sizes, please apply "Source Code". With information technology y'all can change HTML the mode you lot demand. To turn information technology on, become to "Tools" - > "Source Code":

After finishing configuration of email template click "Save".

In example you want to e-mail the existing users as well, enable "Notify existing users" option and set it up as before.

  • By default Joomla has preinstalled extension called "Contacts". You can detect it in your Joomla, Get to:
    Admin Panel->Components->Contacts

    It allows to shop more than data about users like Accost, Urban center, State, Website, etc.

    "Contacts" component allows to create a few contacts and link them to user, so yous can store any corporeality of addresses for each user.

    Our import supports this component and tin can import information from your file into "Contacts".

  • "Welcome" mails are disabled past default, but y'all tin can enable them in advanced settings on Step two. You can even create your own message and ship login/password.

  • Aye, our import supports all characters from UTF-8, for example: Ü, ß, É, 字
    But your file should be in UTF-8

  • Don't match (using sandwich) the password column on step two. The import will create countersign column automatically on step 3

  • You need to practice adjacent steps:
    1. You demand to click on "Switch to Advanced style".
    2. Then you demand to check "Notify newly added users".
    iii. At message dialog click "Tools" then click "Source code"
    4 In "Source lawmaking" editor you tin use HTML to customize your email the manner you need.

  • 1. Your file should comprise column where Groups are separated by comma, e.1000. "Editor, Manager, Administrator". So that one user tin can accept any amount of Groups.
    two. On "Footstep 2 (Settings)" match the column with "Groups" field. Delight note that you lot no longer need to use "Joomla group:" dropbox.

  • Fortunately, in that location is such possibility.
    Joomla has "Require Password Reset" option and when it's enabled user volition be required to change his password on the first/next login.
    To enable this y'all will demand to have column in excel/csv file with values "Yep" (to require countersign reset) and "No" to not require it. And match this column with Joomla "Require Password Reset" field.

  • Fast way to fix this issue is to alter settings in Joomla administrator console. Please go to: Arrangement -> Global Configuration -> Server and modify "Error Reporting" field to "None" value. If information technology don't assistance - delight contact us and provide u.s. with ticket number.

  • Unfortunately Auto updater is not bachelor for this extension.
    To go the latest version of import you lot need:
    1. Go to our website: www.UkrSolution.com
    two. Login and get to "My Products" menu.
    3. Here you will discover all your extensions and tin can download them.

  • To find out the reason why some users tin't be imported - you just need to hover your mouse over the user in tab "Won't exist imported".

  • Our extension is using standard Joomla functions to send emails, so actually we don't have much control on this process. Import extensions just gives email to Joomla and if Joomla's and Server'southward mail configurations are correct - electronic mail will be sent to inbox.

    Then if users don't receive emails the problem might be in:

    1. Wrong Joomla email configuration - enquire your programmer to check it out.
    2. Issues with mail on the server - ask your system administrator to check it out.
    3. Some emails comes to spam/junk folder - ask user to check these folders too.

  • Our extension is using standard Joomla functions to send emails, so actually we don't have much command on this process.

    This issue is based on a few factors, which can be stock-still/changed past server administrator and domain possessor.

    1. Correct mail server configuration
    2. Server'southward IP might be black listed, y'all can check it here: http://mxtoolbox.com/blacklists.aspx
    3. You lot tin use DKIM, SPF, DMARC to make your domains valid for mass mailing
    4. Keep valid reverse DNS records for the IP address(es).

  • Maximum file upload size is a global PHP setting (called upload_max_filesize), you demand to increase this value. Most hosting providers allows to change this setting in your Hosting Control Panel. Too yous can ask your system administrator or programmer to change it.

  • Y'all need to ship email to usa and provide us with details:

    1. How to reproduce problems
    2. Screenshots of bug
    3. All-time way to describe the problem is to create video (you can use software like Jing)

    If yous subscribed to support, you can count on fast update (ane-2 piece of work days)

  • Our extension doesn't support Joomla's auto updater.

    You need to login on our web-site and download last version:
    My Account -> My Products -> Select your product -> Download button
    Later on it yous demand to remove old version from your Joomla and install a new one.

  • If you need some additional features, there are 2 ways:

    1. Send u.s.a. email almost new characteristic, and we will try to implement it in side by side version. As we receiving a lot of suggestions some of them can be rejected.
    2. We can create special release for you, in a short fourth dimension, with all improvements you need for carve up payment. Please contact united states of america to know more almost it.

  • Contact form on our web-site: https://world wide web.ukrsolution.com/ContactUs

faulkhimakinecity.blogspot.com

Source: https://www.ukrsolution.com/Joomla/Import-Users-From-Excel-CSV-File-To-Joomla

You may like these posts

Post a Comment for "How to Upload Products in Bulk in Joomla"