Exporting Quantity Values using the INDIRECT Formula in SellerAmp SAS

Exporting Multi-Unit Totals to Google Sheets

Introduction

If you want to export the cost or sale of a quantity of a product, (let's say you've bought 5 units and wish to export the total cost, sale and profit), you can use a dynamic formula in your SAS Export settings to force Google Sheets to calculate totals based on the Quantity column.

Configure the Product for Export

In the listing, change the Quantity to 5 and press Enter to calculate the prices
Calculating Quantity in SAS's Profit Calculator

Configure Google Sheets for Export

  1. Identify Columns: Note which columns in your Google Sheet contain Quantity (E), Cost Price (F), Sale Price (G) and Profit (H) then add the number of equivalent Formula rows beneath
    Column mapping in SAS Google Sheets setup prior to quantity formula entry

  2. Add Formula to SAS: In your SAS Field Mapping settings, use the following formula for your "Total" column. As an example, the formula for exporting the Total Cost Price to column I would be:
    =INDIRECT("F"&ROW()) * INDIRECT("E"&ROW())

    This formula takes the original Cost Price and multiplies it by the Quantity.
    Inputting quantity formulae to SAS's Google Sheets column mapping

  3. Test & Write Headers: If this is a new sheet, make sure you test and write the headers to your sheet, or, if you're editing an existing sheet, make sure your columns and values line up. Note in the second row how the Quantity Cost, Sale, and Profit correctly export to columns I, J and K but the headers are incorrect.

    Test and Write Headers button in SAS Google Sheets setup

    Quantity formula column mapping in SAS for Google Sheets


    SAS Profit Calculator showing Quantity values

    Google spreadsheet linked to SAS showing correctly exported values with incorrect row names


Export to Google Sheets

To export the quantity, simply configure your Profit Calculator and click Export:
SAS Profit Calculator and Google Sheets panels indicating how to export quantity values


If not already done, make sure your columns are named correctly - testing and writing headers then exporting immediately will leave you with the below.Google spreadsheet linked to SAS showing correctly exported values with stock row names