Importing resources into Zoho SalesIQ

Importing resources into Zoho SalesIQ

The import resource feature in Zoho SalesIQ is a powerful tool that allows you to easily and quickly bulk import articles and FAQs into your account. It is an efficient way to add and edit articles or FAQs quickly and accurately without having to manually edit them one by one. With the import resource feature, you can use a spreadsheet to add and edit multiple articles/FAQs at once, saving you time and effort. Furthermore, you can be assured that the information is accurately imported into your account without any discrepancies.

How do I bulk import articles/FAQs?

To bulk import articles/FAQs,
  1. Log in to your SalesIQ account. Navigate to Settings > Import.
  2. Select Import resources from the options. Now click on the Import button in the top right corner and choose the type of resource you want to import Articles or FAQs.

  1. Click on the Upload icon. You can now drag and drop the sheet or select it using the system file browser.

  1. The spreadsheet must follow the prerequisites for SalesIQ to import it successfully.

Pre-requisites for articles/FAQs import

  1. The spreadsheet must follow the template.
  2. File formats supported: .xls, .xlsx, or .csv

 Understanding the template for resource import 

Article attributes:

Name

Function

Value

Example:

id

A unique ID of an existing article in SalesIQ. It can be set by the user or can be left empty. If an ID is mentioned, the existing article in SalesIQ with the mentioned ID will be updated. If the ID is empty, a new article will be created.

Example: If user provided an ID 3153234, then the existing article with the Id 3153234 will be updated.

 

Note: This field is optional

16 digit ID

group id

To associate the article with a language group. While importing rows in your sheet with the same group ID will be considered as language variants of a single article. 

Example:Row one resource's language is English and Group ID is 2.
Row two resource's language is French and group ID is 2. 

Then these two rows will be considered as the different language variants of the same article. 

Integer

2

language

To associate the article with a supported language.

SalesIQ supported language

french

title

The title of the article.

String

Return policy

content

The body content of the article.

String

This article contains the return instructions…

department

The department to which the article is to be associated.

SalesIQ department name

Marketing

Category

The category under which the articles must be placed.

Category ID

Outbound

Channels

The channels in which this article can be used for self-service.

Web/iOS/android

 

Note: Line breaks separate values.

Web

iOS

is public

Set the visibility of the article. Visitors can view public articles in the self-service knowledge base section. 

Yes/No

Yes,

Status

The status of the article. You can directly publish an article after importing by setting the status as public.

published

draft

FAQ attributes:

Name

Function

Value

Example:

id

A unique ID of an existing FAQ in SalesIQ. It can be set by the user or can be left empty. If an ID is mentioned, the existing FAQ in SalesIQ with the mentioned ID will be updated. If the ID is empty, a new FAQ will be created.

 

Note: This field is optional

16 digit ID

group id

To associate the FAQ with a language group.

Integer

2

language

To associate the FAQ with a supported language.

SalesIQ supported language

french

questions

The question of the FAQ.

String

How do I return a product?

answer

The answer to the FAQ.

String

To return your product...

department

The department to which the FAQ  is to be associated.

SalesIQ department name

Marketing

Category

The category under which the FAQ  must be placed.

Category ID

Outbound

Channels

The channels in which this article can be used for self-service.

Web/iOS/android

 

Note: Line breaks separate values.

Web

iOS

Associate articles

You can associate articles related to this FAQ.

Article ID

is public

Set the visibility of the FAQ.

Yes/No

Yes

Status

The status of the FAQ. You can directly publish an article after importing by setting the status as public.

published

draft 

5. After selecting the spreadsheet from your device, click on Import and Next.


6. Set the status of the article/FAQ once imported.
  1. Draft - Set the article/FAQ status as draft after a successful import.
  2. Published - Set the article/FAQ status as published after a successful import.
  3. Status in sheet - Use the status mentioned in the sheet for each article.
    1. Now, you can map the attribute of the articles to the respective column. Map your column name to the article/FAQ’s attribute. Refer to the table above to know more about the attributes of the articles.
7. Now click on Validate. The validation process will begin.


Validation failure handling

Users can handle those articles/FAQs that failed the validation in one of the following ways and proceed with importing

  • Delete: Hover over the failed record and click on the delete icon
  • Ignore: Check the 'Ignore failed records' check box near the import button. This will ignore all failed records during import.
  • Quick edit: Hover over the failed record and click on edit icon to access quick editor where user can edit the article/FAQ attributes and re-validate.
Note: Users will not be able to edit the content for an article or the answer for an FAQ using quick edit. Any article/FAQ that has issue with the content/answer, will be saved as draft when edited with quick edit.
9. Once, imported, click Done. Now you can view all the imported resources under the Articles or FAQs module. 

Status in import list page


  • Validation pending: Yet to initiate validation by clicking on the Validate button.
  • Validation in-progress: Validation is in-progress.
  • Validated: Validation is completed and import is yet to be started.
  • Import in progress: Import is in-progress.
  • Completed: The import process is completed.

    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION









                                        You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                            Manage your brands on social media

                                              Zoho Desk Resources

                                              • Desk Community Learning Series


                                              • Digest


                                              • Functions


                                              • Meetups


                                              • Kbase


                                              • Resources


                                              • Glossary


                                              • Desk Marketplace


                                              • MVP Corner


                                              • Word of the Day


                                                Zoho Marketing Automation

                                                  Zoho Sheet Resources

                                                   

                                                      Zoho Forms Resources


                                                        Secure your business
                                                        communication with Zoho Mail


                                                        Mail on the move with
                                                        Zoho Mail mobile application

                                                          Stay on top of your schedule
                                                          at all times


                                                          Carry your calendar with you
                                                          Anytime, anywhere




                                                                Zoho Sign Resources

                                                                  Sign, Paperless!

                                                                  Sign and send business documents on the go!

                                                                  Get Started Now




                                                                          Zoho TeamInbox Resources



                                                                                  Zoho DataPrep Resources



                                                                                    Zoho DataPrep Demo

                                                                                    Get a personalized demo or POC

                                                                                    REGISTER NOW


                                                                                      Design. Discuss. Deliver.

                                                                                      Create visually engaging stories with Zoho Show.

                                                                                      Get Started Now









                                                                                                          • Related Articles

                                                                                                          • Integrating Zoho Bookings with Zoho SalesIQ

                                                                                                            Zoho Bookings in SalesIQ Zoho Bookings is an online tool that your customers can use to book appointments with your experts and specialists to avail your services. When you publish your services on Zoho Bookings, your customers can access this ...
                                                                                                          • SalesIQ for Zoho Forms

                                                                                                            Zoho forms is a software solution that let's you create visually appealing forms easily with a no-code online form builder, for all your data collection needs. Integrating Zoho SalesIQ with Zoho Forms will allow you to receive the data collected on ...
                                                                                                          • Desktop apps for SalesIQ

                                                                                                            The SalesIQ Desktop apps are available on the App Store on Mac as well as the Microsoft store on Windows. These can be downloaded from the respective stores to get the the SalesIQ experience right to your desktop. Mac Downloading the SalesIQ app from ...
                                                                                                          • Integrating Whatsapp Channel with SalesIQ

                                                                                                            Integrating WhatsApp business with your SalesIQ helps you handle your business' WhatsApp chat conversations on your SalesIQ dashboard. Let your visitors contact you from the convenient channel, and your operators can handle the chat from their ...
                                                                                                          • Payment gateways for SalesIQ-Checkout Integration

                                                                                                            The following are the list of payment gateways supported on SalesIQ. Each payment gateway has its own flow for configurations. Stripe Authorize.Net 2Checkout PayPal Forte Razorpay Paytm PayTabs Note The payment gateway list provided in the Add ...
                                                                                                            Wherever you are is as good as
                                                                                                            your workplace

                                                                                                              Resources

                                                                                                              Videos

                                                                                                              Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                              eBooks

                                                                                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                              Webinars

                                                                                                              Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                              CRM Tips

                                                                                                              Make the most of Zoho CRM with these useful tips.



                                                                                                                Zoho Show Resources