Enter Your Cost of Goods Sold (COGS)

Enter your Cost of Goods Sold (COGS) into VendorPayout so that they are subtracted prior to vendor split calculations. VendorPayout gives you the ability to enter your COGS by SKU one at a time or to import a CSV file containing your cost of goods for all SKUs in bulk.

Note: If you prefer to use Shopify's Cost-per-item field, please contact our support team (support@vendorpayout.com) and we can set up a daily sync to pull in the Shopify's Cost-per-item field.

Enter Cost of Goods - One at a Time

This method is best when you only have a few SKUs for which you need to enter your cost of goods.

1. Launch VendorPayout and go to Settings.
   
   
2. Locate the Cost of Goods (by SKU) section and click the Create New Cost of Goods button.
   
   
3. Fill in the following information. (* indicates a required field)
   1. Product SKU*
   2. Description
   3. Cost*
      
      
4. Click the Submit button.
   

The new Cost of Good will be displayed in the Cost of Goods (by SKU) section of the Settings screen.

A new Cost column will also be added to the Orders screen.

Upload Cost of Goods - in Bulk

Use this method to create a CSV file containing the cost of goods for all of your SKUs that can be upload into VendorPayout. This method is best when you have a large number of SKUs that need to be entered.

1. Launch VendorPayout and go to Settings.
   
   
   
2. Locate the Cost of Goods (by SKU) section.
   
   
3. Download the CSV file template by clicking the Download the CSV link.
   This file is formatted with the appropriate column headings.
   
   
4. Locate the file in your web browser's downloads folder and open it into your favorite spreadsheet program.
   Leave the column heading names in row A. Enter the following information into the sheet and save it.
   1. SKU: Be sure that the SKUs you enter match the SKUs in VendorPayout so that the cost will associate to the correct product when imported.
   2. Cost: The cost associated with the SKU.
   3. Status: Indicates the current status of the cost of goods. Enter as Enabled or Disabled. If the field is left blank, Disabled is assumed.
      
      
5. Click the Choose File button. Then, navigate to your CSV file and select it.
   The file will be uploaded as soon as you open it.
   
   You will be presented with a success message after the file is imported.
   
   The new Cost of Good will be displayed in the Cost of Goods (by SKU) section of the Settings screen.
   
   A new Cost column will also be added to the Orders screen.
   

Edit Your Cost of Goods

1. Locate the Cost of Goods (by SKU) section of the Settings screen.
2. Click the Edit link to the right of the cost you wish to edit.
   
   
3. Update the appropriate information. Then, click the Submit button.
   

Additional Reading

• Learn more about the VendorPayout settings