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

    • Related Articles

    • Performing calculations within SellerAmp

      Within editable fields in SAS which require numerical input, you can perform calculations using basic mathematical functions, as well as brackets. What is it? Any amount box can now handle common math operations, including addition (+), subtraction ...

    • Customising your SellerAmp searches with variables

      The below variables can be used to specify aspects of your sourcing in the URL, separated by '&' - all attributes apply to selling except tp_integration_token: Attribute Name Description Notes tp_integration_token Token provided by SellerAmp for the ...

    • Typing a decimal point for non-UK/US keyboards on the mobile app

      In the Profit Calculator panel of SAS's mobile app, you might notice decimal points work differently depending on the keyboard; with a UK or US keyboard, you can manually add the decimal point when entering prices, so if you want to enter "3.60", you ...

    • Using SellerAmp SAS on an iPad

      If you are using an iPad, you'll need to download the mobile app from the App Store or Google Play, which contains the same functions as the Chrome extension; you may find these videos helpful about using the mobile app and the Split View feature. ...