Conviu help and FAQ
  • Introduction to the Conviu application
  • Information about Conviu
    • All the features of Conviu
    • How does Conviu work?
    • Who can use Conviu?
    • Registration
    • Price for Conviu
    • Billing information settings
    • Change of billing period
    • Language settings in Conviu
    • Add a user to the organization
    • Add an organization/add an e-shop
  • Data editing (XML and CSV)
    • Conviu as an XML editor
    • Data import
    • Data import - XML, FTP, web services, from file, additional import, retrieve data from Google sheets
    • Import error - feed cannot be read
    • XML Suppliers for e-shop
    • Custom import - import of your own (any) xml
    • Import data - load from Google Sheets table
    • Data export
    • Custom export - export of your own (any) xml
    • Variants in Custom XML / CSV / XLSX export
    • Export timer
    • Connecting of several XML
    • Additional import - Additional XML feed (csv, xls, web services, FTP)
    • Data export - download data from XML to csv
    • Where to get the URL of the XML feed Zboží.cz?
    • How to insert XML (URL of new export) into Zboží.cz?
    • Where to get the URL of the Heureka XML feed?
    • How to insert XML (URL of new export) into Heureka.cz?
    • Data editing - rules
    • Add an element
    • Edit an element
    • Hide an element
    • Hide the entire product
    • Bulk edit
    • Bulk editing of data
    • Bulk edit data - Google Sheets
    • Editing variants - rules for variants
    • The rule for adding a gift
    • How to create a custom label - g: custom_label?
    • Edit name - PRODUCTNAME
    • Rule for rewriting categories in XML
    • Rule for setting the price of transport - DELIVERY
    • Date adjustment rule (e.g. availability date)
    • The rule for hiding an element
    • The rule for hiding the product
    • How to adjust the selling price to another currency?
    • Adjustments within the rules - calculator
    • Editing within rules - nested structure - transport - DELIVERY
    • Parameter creation - PARAM
    • Pairing products on Heureka - Heureka pairer
    • Unformatted text (text without HTML characters)
    • A variable of type list (List variable) and separation into multiple elements
    • Automatic translation - of whole XML or only selected products. Automatic website translator
    • Detailed overview of changes at the product level
    • Page Feed for Google Ads or DSA for PPC
    • How to embed Page Feed in Google Ads?
    • Connection to Mall Marketplace
  • Automatic Bidding
    • What is a bidding?
    • Bidding strategy
    • Settings for automatic bidding
  • Pricing
    • Why Pricing?
    • Pricing strategies
  • Other
    • Suspension of the organization (e-shop)
    • Deleting an organization (e-shop)
  • Localization
    • 🇨🇿Čeština
    • 🇺🇸English
    • 🇩🇪Deutsch
Powered by GitBook
On this page

Was this helpful?

  1. Data editing (XML and CSV)

Import data - load from Google Sheets table

PreviousCustom import - import of your own (any) xmlNextData export

Last updated 3 years ago

Was this helpful?

We have created a novelty for you in the field of import, which will make your further work easier. Conviu now offers to import data conveniently from Google sheets.

Wondering how to do it? Let's take a look:

When you are importing data, there is a new Google Sheets option in the feed store.

After choosing the Google sheets feed, a table will open for you, which you must fill in. It's not difficult, see the picture below. With this method, all you have to do is share the file you want, enter the URL address and select the sheet to import.

Then you only need to assign the corresponding elements to complete the import.

Individual elements can be assigned up to the lowest levels. For example: select "Channel (XML root)" for the "CATALOG" element or select "Item (E-shop goods)" for "PRODUCT". Then just pair the elements he needs (brand, purchase price, etc.)

Pairing CHANNEL (XML root), ITEM (Goods in e-shop) and ID (unique identifier) are mandatory in order to save the import.

See below for a pairing example.