Gsheet Overview (EN)

| 13 minutes

Gsheet Overview (EN)

The gsheets used for uploading EN product information on the website are saved in the Drive in each range folder:
Z:\Shared drives\Website Projects\AC - advacarepharma.com\Version 4 (2022)\Design Phase\5. Content

Header Column

Header column refers to the first column in the gsheet, which contains the titles of each row.

Header column is the most important part of the gsheet, which allows the script to understand what information to put where on the page, or in other words, each header in the gsheet correlates with the relevant fields in WordPress.
Therefore, the names of rows in the header column should never be edited. If the header column is edited then the script will not connect the information in the cells with the correct WordPress fields.

The list of headers:

  1. LINK
    Refers to the URL of the product. If the cells contain incorrect URL then the final product on the website will also have incorrect URL.
  2. PRODUCT
    Refers to the name of the product, or in other words, H1.
  3. CATEGORY
    Refers to the category/sub-category which the product belongs to (L3 page). The field is filled out with the relevant L3 page slug. Slugs are obtained from WP of the relevant L3 page. Slug in the gsheet must match the field “Slug” in WP of the relevant L3 page, otherwise, the product will not be displayed in the relevant L3 page.
  4. BRAND NAME
    Refers to the brand name of the product, which is displayed right under the product name on the webpage. If there is more than one brand name (which is possible for some products), then the second brand name should be added to the next row under the same header title:
  5. PRODUCT INFORMATION
    Refers to the short and concise product description displayed under the brand name on the product page.
  6. PAGE TITLE TAG
    Refers to Meta Title of the product page. This title is very important for SEO, and serves 2 purposes: it is displayed in the name of the tab for the user to know which tab is opened; it is displayed in the featured snippet in Google search results. Title tag must follow the format:
    Product Name - Manufacturer | AdvaCare Pharma
  7. PAGE META DESCRIPTION
    Refers to Meta Description of the webpage. Meta Description is the most important field for SEO, it is not displayed to the user on the webpage, but it is displayed in Google search results as a featured snippet. This field is used by Search Engines to understand what the page is about.
  8. KEYWORDS
    Refers to the main keyword of the page. This field must match the product name, and is used by the script to be added to Yoast plugin, the field “Focus keyphrase”. This field is an internal Yoast field that helps the plugin to evaluate the content of the page and provide feedback on improvements.
  9. BEST SELLER
    This field is not used by the script.
  10. IMAGE ALT TAG
    Refers to the alt tag of the main images displayed in the product images slider on the product pages. Alt tag is very important for SEO. Alt tags usually follow the format:
    Product Name (box of XX)The part in parenthesis indicates the packaging of the product which is displayed on the image.
  11. IMAGE FILENAME
    Refers to the filenames of the main images displayed in the product images slider on the webpage. The filenames in the gsheet must be exactly the same as the actual filenames of the images saved in the server. If the image filename in the gsheet doesn’t match the image file name in the server then the image will not be displayed on the webpage.
  12. DOSAGE/FORM/COMPOSITION/ATTRIBUTE 1/STRAIN/etc (depends on the range)
    Refers to product’s dosage in case of Pharmaceutical and Veterinary ranges. This is the first field of product attributes displayed on the webpage. Dosage is the first attribute displayed for most Pharmaceutical and Veterinary products. The first attribute in the gsheet will also be the first attribute displayed on the page.
    Depending on the name of the row in the header, the field displayed on the website might have different types. “Dosage” attribute has the default field type “Simple”.
    More information about different attribute types can be found below, in “Attribute Types” section of this SOP.
  13. PACKAGING
    Refers to product packaging displayed on each product webpage. The default attribute type of this field is “Selector”, which means dropdown.
  14. SECTIONS
    Refers to the starting point of all content blocks displayed on the product page. All sections/content blocks can go one by one without the need to repeat the header title “SECTIONS” for each new section, as long as they are not interrupted by other fields/headers. If the sequence is interrupted by another header, when restarting the sections add the header “SECTIONS” again. Each section name in each product column must follow a predefined format.
  15. SHORT NAME (Pharmaceutical Topicals and Supplements ranges gsheets)
    Refers to the name of the product displayed on the L3 page. As some of the products in Supplements range have multiple forms, and product name (H1) only contains one form (the most searched or most common form of the product), the name of the product displayed on the L3 page must include all the product forms in the product name, otherwise it will confusing for the user.
  16. SUBTITLE (Medical Devices range gsheet)
    Refers to the second part of “BRAND NAME” in Medical Devices products. For example, the BRAND NAME is “AccuPoint™”, and SUBTITLE is “Injection Instruments”. Both are displayed in the same place under the product name, but SUBTITLE has different formatting (cursive and not bold).
  17. MED DEVICES LAYOUT DESIGN/DESIGN STRUCTURE (Medical Devices and Supplements ranges gsheets)
    Refers to the layout that is being used for each Medical Devices product. There are 3 options of the design layout: Simple (no specs), Multi Specs (no img), and Multi Specs (with img). These layouts refer to the Paragraph Type used for Product Specifications section of each product, which is described in detail in “Paragraph Types” of this SOP
  18. ACTIVE INGREDIENTS/THERAPEUTIC CLASS/TARGET SPECIES/ASTERISK
    (Pharmaceutical Topicals and Veterinary range gsheets)
    These rows are not used by the script and are only for the editor reference.

This field is not used by the script.

Attributes are specific characteristics or features of a product that provide additional information about its qualities, specifications, or properties. Product attributes help describe and differentiate one product from another, allowing customers to make informed purchasing decisions. For Pharmaceutical products, the most common attributes are Dosage and Packaging.
Attributes are displayed on top of each product page under the Product Description in the same order as how they are placed in the gsheet.

Attribute Types are types of the field that includes options of each Attribute. For example, in the image above the “Dosage” attribute has 5 options, or 5 values, which are displayed in the form of buttons. At the same time, “Packaging” attribute is displayed in the form of a dropdown.

Attribute Types

The website has 5 different Attribute Types:

  1. Simple
    “Simple” Attribute Type refers to displaying the attribute values in the form of buttons. This type is used when there are multiple values (not more than 6), with each of them being short enough to be displayed in a button.
  2. Text
    “Text” Attribute Type refers to displaying the attribute value in the form of text. This type is used when there is only one attribute value, which usually contains long text (for example, long composition).
  3. With Unit
    “With Unit” Attribute Type refers to a very specific case of Tablets/Capsules/Softgels that belong to the Supplements range. This attribute type is used for the “Pack Size” attribute and highlights the number of units in one box in bold.
  4. Composition
    “Composition” Attribute Type is mainly used for products from Supplements range. It displays the values in the form of buttons, and adds a link “View full composition >” right under the buttons which takes the used down to “Composition” content block.
  5. Selector
    “Selector” Attribute Type displays the attribute values in the form of a dropdown. This type is mainly used when there are multiple attribute values (more than 6), or if each attribute value is long.

Default Attribute Types

Some Attribute Types are predefined according to the structure of attribute values. The predefined Attribute Types means that by default a certain attribute with a certain name will have a certain attribute type. For example, “Dosage” attribute has default attribute type “Simple”, because most of the products’ dosages have multiple values with short text, which should be displayed in the form of buttons.
Below is the list of default attribute types:

  • Dosage: Simple
  • Packaging: Selector
  • Form: Simple
  • Strain: Simple
  • Specimen: Simple
  • Composition: Composition
  • Pack Size: Simple
  • Attribute 1/Attribute 2/…/Attribute N: Simple
    • Attribute 1/Attribute 2/…/Attribute N are mostly used for the Medical Devices range, as Medical Devices have too many attributes that depend on each product’s specifications.

Attribute Groups

Sometimes the product specifications have interdependencies, when only some options of one specification can be combined with some options of another specification. In other words, when not all combinations of options under different specifications exist.

Supplements range has some interdependencies between the product forms and compositions, when a certain composition can only fit into a tablet form, and another composition can be suitable for both tablet and capsule forms.

Medical Devices range has a lot of different attributes due to the complexity of the product specifications of Medical Devices, and many of them have interdependencies.

For example, Rapid Test Kits (such as Covid-19 Test Kits) might have different Types and the Specimen will depend on the Type selected. Covid-19 Antibody test kit has Whole Blood/Serum/Plasma specimen, and Covid-19 Antigen test kit has Nasopharyngeal or Saliva specimen.
For such cases, the website must not let the user combine the specifications which should not be combined. To let the website display the specifications correctly, attributes are combined in “Groups”.
“Groups” functionality means that every option of one specification is assigned with a relevant group, which then is applied to the options of another specification to indicate that they need to be dependent.

To assign a group for each option of the first specification the following code is used in the gsheet:
[Group Name] => [Option Details]
For example, to assign a group to Covid-19 Antibody option of Type specification, the group “Antibody” will be added to the option:
Antibody => COVID-19 Antibody Test Kit
Where “Anitbody” is the name of the group, and “COVID-19 Antibody Test Kit” is the text of the option.
Similarly, second option of Type specification, “Covid-19 Antigen Test Kit” is assigned with the group “Antigen”:Antigen => COVID-19 Antigen Test Kit

After the groups are assigned to the first specification, the same groups need to be assigned to all other attributes of the product to combine the specifications options that work with these groups.

There are 2 ways to assign the defined groups to subsequent specifications:

  1. Repeat the same format for each specification option:
    [Group Name] => [Option Details]
    For example, to assign Antibody and Antigen groups to Specimen specification, each group can be added to the cell in the following way:

    This way it is clear that the “Antibody” group applies only to “Whole Blood/Serum/Plasma” specimens, and the “Antigen” group applies to “Nasopharyngeal” and “Saliva” specimens.
  2. When multiple groups apply to several or all options, then the shorter way to assign existing groups is to add the following code in a separate cell under the Attribute Title:
    Groups: [Group Name], [Group Name]
    For example, “Covid-19 Test Kits” product has 2 more attributes: Form and Packaging. All the options under both of these specifications apply to both groups. Therefore, the format to add this code to the gsheet will be the following:

NOTE: if there is at least one attribute that has groups assigned, then all the other attributes under the same product MUST have the groups assigned as well. If there are groups assigned to one attribute but not the rest, then the website will display all options of the rest attributes in gray as not matching with any group. The user in this case will not be able to choose all product specifications.

On the website Attribute Groups and interdependencies functionality works by graying out the options not available when a certain specification is selected:

Sections

Sections are the content blocks located under the Attributes.

Paragraph Types

Paragraph Type is the visual representation of the content block, how the block of text is displayed on the website.

There are 4 different Paragraph Types in WordPress:

  • “All Visible” Paragraph Type: paragraph type which displays the information via standard unfolded text, which can contain multiple subtitles. This is the most simple and most common Paragraph Type. Almost all content blocks described above have “All Visible” Paragraph Type by default, as it is the best design of content due to its simplicity and being SEO friendly. Any other content block type hides the content which is considered bad for SEO, therefore, “All Visible” paragraph type should be used as much as possible.
    Examples:
  • “Accordion” Paragraph Type: paragraph type which displays the list of subtitles with the information of each subtitle (except the first one) hidden by default. Users must click on each subtitle to unfold the content.
    Examples:
  • “Specification” Paragraph Type: paragraph type which displays the product specifications in the form of buttons, that unfold the information which usually includes images.
    Examples:
    ">
  • “Icons” Paragraph Type: paragraph type which displays 6 icons and 6 short USPs under each icon.

    • All the sections on the website follow the design of one of the Paragraph Types. The decision of which Paragraph Type to use for each section depends on the content of each section.

Paragraph Types

There are 15 different content blocks by title. These content blocks are used in different ranges.

  1. “What is…” section: explains what the product is and provides basic information about the product. This section always contains a header with a link to the Indication page or, in the case of Medical Devices products, also a link to the L3 page which contains the product. For Pharmaceuticals/Veterinary ranges this section also contains “Active Ingredients” information.
    “What is…” section uses “All Visible” Paragraph Type by default.

    In the gsheet, this section is always first under the “Sections” header.
  2. “Uses” section: explains how the product is used. This section usually contains at least 3 subtitles which are made in the form of a question, and text under each subtitle which answers these questions.
    “Uses” section has “All Visible” Paragraph Type by default.
  3. “Why are we…/Why choose…” section: contains multiple versions of the title, for example “Why are we a leading XX manufacturer?”, or “Why choose us as your XX manufacturer?”, etc. This section talks about AdvaCare being the manufacturer of the product, and is mainly targeted to capture searches containing the word “manufacturer”.
    “Why are we…/Why choose…” section uses “All Visible” Paragraph Type by default.
  4. “Side Effects” section: contains side effects information mainly for Pharmaceutical and Veterinary products. This section might contain a long list of side effects with bullet points.
    “Side Effects” section uses “All Visible” Paragraph Type by default.
  5. “Precautions” section: contains precautions information mainly for Pharmaceutical and Veterinary products. This section might contain a list of precautions with bullet points.
    “Precautions” section uses “All Visible” Paragraph Type by default.
  6. “Uses” section: explains how the product is used. This section usually contains at least 3 subtitles which are made in the form of a question, and text under each subtitle which answers these questions.
    “Uses” section has “All Visible” Paragraph Type by default.
  7. “Uses” section: explains how the product is used. This section usually contains at least 3 subtitles which are made in the form of a question, and text under each subtitle which answers these questions.
    “Uses” section has “All Visible” Paragraph Type by default.
  8. “Uses” section: explains how the product is used. This section usually contains at least 3 subtitles which are made in the form of a question, and text under each subtitle which answers these questions.
    “Uses” section has “All Visible” Paragraph Type by default.
  9. “Uses” section: explains how the product is used. This section usually contains at least 3 subtitles which are made in the form of a question, and text under each subtitle which answers these questions.
    “Uses” section has “All Visible” Paragraph Type by default.
  10. “Uses” section: explains how the product is used. This section usually contains at least 3 subtitles which are made in the form of a question, and text under each subtitle which answers these questions.
    “Uses” section has “All Visible” Paragraph Type by default.
  11. “Uses” section: explains how the product is used. This section usually contains at least 3 subtitles which are made in the form of a question, and text under each subtitle which answers these questions.
    “Uses” section has “All Visible” Paragraph Type by default.

Previous Post

Did this article help you?
 0
 0