Overview
This article will cover how to use the Pricing & Costing CSV import/export functionality in OpenSolar. This functionality will allow you to quickly download, update and re-upload your pricing and costing settings in OpenSolar in order to greatly reduce the admin time needed for this.
There are three main places in the app where this functionality is available:
- Control > Pricing & Payments > Price Schemes
- Control > Pricing & Payments > Cost Schemes
- Control > Design & Hardware > Modules / Inverters / Batteries / Other Components
For each of these sections you will see that there are two buttons at the bottom of the list view:
- Download
- Upload
Download
The download button will download the current list of all of your non-archived pricing schemes/costing/schemes/modules/inverters/batteries/other components. You can use this as a way to see what the format for upload is.
You can also use this as a way to quickly to update your pricing/costing by simply downloading the current list, updating the pricing/costing values and re-uploading.
Upload
If you click on the Upload button you will get a dialog which will look slightly different depending on which screen you are on, but it will look something like this:
You can either drag and drop or click and select a .csv file to upload here. You can also download your list to see what the format looks like for uploading. Please see the corresponding sections below for a description on the fields in each CSV.
Please note that you cannot activate or create components currently with this feature. However, you can create new pricing/costing schemes.
Troubleshooting uploads
After you have uploaded a file you will see this:
If you click "View Details" you will be able to see if there were any issues with the upload. Clicking it will take you to a list view of the previous CSV uploads on your account.
From here you can see that for 12 of the 27 rows there were warnings. You can then click on the 12 to get more info on these warnings and fix any thing that needs updating. If any rows in your CSV are invalid, they will be skipped.
The warning message that you get for each skipped row should explain what needs to be updated to get it working. Otherwise, please refer to the relevant field in the below tables for a description of the input format.
CSV formats
The columns available in the each of the CSVs are shown in the corresponding tables below with a list of descriptions.
Price Schemes CSV format
| Value | Description | Input format |
| title | Title | String |
| id | Leave this blank if you are creating a new scheme, or leave it as you downloaded it in order to update an existing scheme. | Integer |
| priority | Pricing schemes with a larger priority value will be selected in priority over others. | Integer |
| pricing_formula | Enter one of the pricing formulae on the right in order to select the pricing formula you wish to use. | Fixed Price/Markup Percentage/Price Per Watt By Size/Price Per Watt |
| auto_apply_component_codes | List of comma separated component codes that are required to be on a system before this scheme is auto applied. | Comma separated values |
| auto_apply_enabled | True = auto apply is ON. False = auto apply is OFF. | True/False |
| auto_apply_max_system_size | The maximum system size that this scheme will be auto applied at. | Number |
| auto_apply_min_system_size | The minimum system size that this scheme will be auto applied at. | Number |
| auto_apply_only_specified_states | List of comma separated states where this scheme is auto applied. | Comma separated values |
| auto_apply_only_specified_zips | List of comma separated zips where this scheme is auto applied. | Comma separated values |
| auto_apply_sector | 0 = Any, 1 = Residential, 2 = Commercial. | 0/1/2 |
| is_archived | True = this scheme is archived. False = this scheme is not archived. | True/False |
| tax_percentage_included | The amount of tax that is included in the price for this pricing scheme. | Number from 0-100. |
| tax_mode | including = the price given for this scheme is inclusive of tax. excluding = the pice given for this scheme is exclusive of tax. | including/excluding |
| price (Fixed price formula ONLY) | The price used for fixed price. | Number |
| markup_percentage (Markup formula ONLY) | The amount of markup applied to the total costs of the system. | Number from 0-100 |
| deduct_incentive_to_installer_before_markup (Markup formula ONLY) | True = deduct the incentives to installer before the markup is applied. False = deduct the incentives to installer after the markup is applied. | True/False |
| price_per_watt (Price per watt formula ONLY) | The price per watt of solar for the scheme. | Number |
| battery_price_per_kwh (Price per watt formula ONLY) | The price per kWh of batteries for the scheme. | Number |
| price_per_watt_0_1 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 0-1kW. | Number |
| price_per_watt_1_2 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 1-2kW. | Number |
| price_per_watt_2_3 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 2-3kW. | Number |
| price_per_watt_3_4 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 3-4kW. | Number |
| price_per_watt_4_5 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 4-5kW. | Number |
| price_per_watt_5_6 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 5-6kW. | Number |
| price_per_watt_6_7 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 6-7kW. | Number |
| price_per_watt_7_8 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 7-8kW. | Number |
| price_per_watt_8_9 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 8-9kW. | Number |
| price_per_watt_9_10 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 9-10kW. | Number |
| price_per_watt_10_12 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 10-12kW. | Number |
| price_per_watt_12_14 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 12-14kW. | Number |
| price_per_watt_14_16 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 14-16kW. | Number |
| price_per_watt_16_18 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 16-18kW. | Number |
| price_per_watt_18_20 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 18-20kW. | Number |
| price_per_watt_20_30 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 20-30kW. | Number |
| price_per_watt_30_40 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 30-40kW. | Number |
| price_per_watt_40_50 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 40-50kW. | Number |
| price_per_watt_50_60 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 50-60kW. | Number |
| price_per_watt_60_70 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 60-70kW. | Number |
| price_per_watt_70_80 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 70-80kW. | Number |
| price_per_watt_80_90 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 80-90kW. | Number |
| price_per_watt_90_100 (Price per watt by size formula ONLY) | The price per watt of solar for systems between 90-100kW. | Number |
| price_per_watt_100_plus (Price per watt by size formula ONLY) | The price per watt of solar for systems 100kW+. | Number |
| battery_price_per_kwh_0_5 (Price per watt by size formula ONLY) | The price per kWh of batteries for systems between 0-5kWh. | Number |
| battery_price_per_kwh_5_10 (Price per watt by size formula ONLY) | The price per kWh of batteries for systems between 5-10kWh. | Number |
| battery_price_per_kwh_10_100 (Price per watt by size formula ONLY) | The price per kWh of batteries for systems between 10-100kWh. | Number |
| battery_price_per_kwh_100_plus (Price per watt by size formula ONLY) | The price per kWh of batteries for systems 100kWh+. | Number |
Cost Schemes CSV format
| Value | Description | Input Format |
| title | Title of the costing scheme. | String |
| id | Leave this blank if you are creating a new scheme, or leave it as you downloaded it in order to update an existing scheme. | Integer |
| priority |
True = automatically apply this costing scheme False = do not automatically apply this costing scheme |
True/False |
| is_archived |
True = this costing scheme is archived False = this costing scheme is not archived |
True/False |
| description | A short description of the costing scheme. | String |
| allocation_of_lead_gen_per_panel | The cost per panel for allocation of lead generation. |
Number |
| allocation_of_lead_gen_per_system | The cost per system for allocation of lead generation. | Number |
| allocation_of_lead_gen_per_watt | The cost per watt for allocation of lead generation. | Number |
| allocation_of_salary_per_panel | The cost per panel for allocation of salary. | Number |
| allocation_of_salary_per_system | The cost per system for allocation of salary. | Number |
| allocation_of_salary_per_watt | The cost per watt for allocation of salary. | Number |
| auto_apply_component_codes | List of comma separated component codes that are required to be on a system before this scheme is auto applied. |
Comma separated values |
| auto_apply_max_system_size | The maximum system size that this scheme will be auto applied at. | Number |
| auto_apply_min_system_size | The minimum system size that this scheme will be auto applied at. | Number |
| auto_apply_only_specified_states | List of comma separated states where this scheme is auto applied. | Comma separated values |
| auto_apply_only_specified_zips | List of comma separated zips where this scheme is auto applied. | Comma separated values |
| auto_apply_priority | Costing schemes with a larger priority value will be selected in priority over others. | Number |
| auto_apply_sector | 0=Any, 1 = Residential, 2 = Commercial |
0/1/2 |
| bos_per_panel | Balance of System costs per panel. | Number |
| bos_per_system | Balance of System costs per system. | Number |
| bos_per_watt | Balance of System costs per watt. | Number |
| commission_per_panel | Commission cost per panel. | Number |
| commission_per_system | Commission cost per system. | Number |
| commission_per_watt | Commission cost per watt. |
Number |
| commission_percentage_of_cogs_and_labor | Commission cost as a percentage of COGS and labour costs. | Number |
| custom_acquisition_cost_1_per_panel | The first custom acquisition cost per panel (if set). | Number |
| custom_acquisition_cost_1_per_system | The first custom acquisition cost per system (if set). | Number |
| custom_acquisition_cost_1_per_watt | The first custom acquisition cost per watt (if set). | Number |
| custom_acquisition_cost_2_per_panel | The second custom acquisition cost per panel (if set). | Number |
| custom_acquisition_cost_2_per_system | The second custom acquisition cost per system (if set). |
Number |
| custom_acquisition_cost_2_per_watt | The second custom acquisition cost per watt (if set). | Number |
| custom_acquisition_cost_3_per_panel | The third custom acquisition cost per panel (if set). | Number |
| custom_acquisition_cost_3_per_system | The third custom acquisition cost per system (if set). | Number |
| custom_acquisition_cost_3_per_watt | The third custom acquisition cost per watt (if set). | Number |
| custom_cogs_cost_1_per_panel | The first custom COGS cost per panel (if set). | Number |
| custom_cogs_cost_1_per_system | The first custom COGS cost per system (if set). |
Number |
| custom_cogs_cost_1_per_watt | The first custom COGS cost per watt (if set). | Number |
| custom_cogs_cost_2_per_panel | The second custom COGS cost per panel (if set). | Number |
| custom_cogs_cost_2_per_system | The second custom COGS cost per system (if set). | Number |
| custom_cogs_cost_2_per_watt | The second custom COGS cost per watt (if set). | Number |
| custom_cogs_cost_3_per_panel | The third custom COGS cost per panel (if set). | Number |
| custom_cogs_cost_3_per_system | The third custom COGS cost per system (if set). |
Number |
| custom_cogs_cost_3_per_watt | The third custom COGS cost per watt (if set). | Number |
| custom_cogs_cost_4_per_panel | The fourth custom COGS cost per panel (if set). | Number |
| custom_cogs_cost_4_per_system | The fourth custom COGS cost per system (if set). | Number |
| custom_cogs_cost_4_per_watt | The fourth custom COGS cost per watt (if set). | Number |
| custom_cogs_cost_5_per_panel | The fifth custom COGS cost per panel (if set). | Number |
| custom_cogs_cost_5_per_system | The fifth custom COGS cost per system (if set). |
Number |
| custom_cogs_cost_5_per_watt | The fifth custom COGS cost per watt (if set). | Number |
| custom_fulfillment_cost_1_per_panel | The first custom fulfillment cost per panel (if set). | Number |
| custom_fulfillment_cost_1_per_system | The first custom fulfillment cost per system (if set). | Number |
| custom_fulfillment_cost_1_per_watt | The first custom fulfillment cost per watt (if set). | Number |
| custom_fulfillment_cost_2_per_panel | The second custom fulfillment cost per panel (if set). | Number |
| custom_fulfillment_cost_2_per_system | The second custom fulfillment cost per system (if set). |
Number |
| custom_fulfillment_cost_2_per_watt | The second custom fulfillment cost per watt (if set). | Number |
| custom_fulfillment_cost_3_per_panel | The third custom fulfillment cost per panel (if set). | Number |
| custom_fulfillment_cost_3_per_system | The third custom fulfillment cost per system (if set). | Number |
| custom_fulfillment_cost_3_per_watt | The third custom fulfillment cost per watt (if set). | Number |
| design_drawings_per_panel | Cost for design drawings per panel. | Number |
| design_drawings_per_system | Cost for design drawings per system. |
Number |
| design_drawings_per_watt | Cost for design drawings per watt. | Number |
| job_site_shipping_and_warehousing_per_panel | Cost for job site shipping and warehousing per panel. | Number |
| job_site_shipping_and_warehousing_per_system | Cost for job site shipping and warehousing per system. | Number |
| job_site_shipping_and_warehousing_per_watt | Cost for job site shipping and warehousing per watt. | Number |
| labor_per_panel | Labour cost per panel. | Number |
| labor_per_system | Labour cost per system. | Number |
| labor_per_watt | Labour cost per watt. |
Number |
| other_costs_per_panel | Other costs per panel. | Number |
| other_costs_per_system | Other costs per system. | Number |
| other_costs_per_watt | Other costs per watt. | Number |
| permit_costs_per_panel | Costs for permitting per panel. | Number |
| permit_costs_per_system | Costs for permitting per system. | Number |
| permit_costs_per_watt | Costs for permitting per watt. |
Number |
| phase_1_cost_per_panel | Costs for single phase systems per panel. | Number |
| phase_1_cost_per_system | Costs for single phase systems per system. | Number |
| phase_1_cost_per_watt | Costs for single phase systems per watt. | Number |
| phase_2_cost_per_panel | Costs for two phase systems per panel. | Number |
| phase_2_cost_per_system | Costs for two phase systems per system. | Number |
| phase_2_cost_per_watt | Costs for two phase systems per watt. | Number |
| phase_3_cost_per_panel | Costs for three phase systems per panel. |
Number |
| phase_3_cost_per_system | Costs for three phase systems per system. | Number |
| phase_3_cost_per_watt | Costs for three phase systems per watt. | Number |
| presale_software_and_design_per_panel | Costs for presale software and design per panel. | Number |
| presale_software_and_design_per_system | Costs for presale software and design per system. | Number |
| presale_software_and_design_per_watt | Costs for presale software and design per watt. | Number |
| project_management_per_panel | Project management cost per panel. |
Number |
| project_management_per_system | Project management cost per system. | Number |
| project_management_per_watt | Project management cost per watt. | Number |
| racking_per_panel | Racking cost per panel. | Number |
| racking_per_system | Racking cost per system. | Number |
| racking_per_watt | Racking cost per watt. | Number |
| roof_type_adder_1_cost_per_panel | Cost per panel for roof type 1. | Number |
| roof_type_adder_1_cost_per_system | Cost per system for roof type 1. | Number |
| roof_type_adder_1_cost_per_watt | Cost per watt for roof type 1. | Number |
| roof_type_adder_1_roof_type |
Roof type 1 6 = Composition/Asphalt Shingle 7 = Flat Concrete 8 = Flat foam 9 = Membrane EPDM 10 = Membrane PVC 11 = Membrane TPO 12 = Metal Decramastic 13 = Metal Shingle 14 = Metal standing seam 15 = Metal stone coated 16 = Metal tin 17 = tar and gravel / bitumen 18 = Thatched 19 = Tile Clay 20 = Tile Concrete 21 = Tile slate 22 = Wood shake/shingle 23 = Other 24 = Kliplock |
6/7/8/9/10/11/12/13/14/15/16/17 /18/19/20/21/22/23/24 |
| roof_type_adder_2_cost_per_panel | Cost per panel for roof type 2. | Number |
| roof_type_adder_2_cost_per_system | Cost per system for roof type 2. | Number |
| roof_type_adder_2_cost_per_watt | Cost per watt for roof type 2. | Number |
| roof_type_adder_2_roof_type |
Roof type 1 6 = Composition/Asphalt Shingle 7 = Flat Concrete 8 = Flat foam 9 = Membrane EPDM 10 = Membrane PVC 11 = Membrane TPO 12 = Metal Decramastic 13 = Metal Shingle 14 = Metal standing seam 15 = Metal stone coated 16 = Metal tin 17 = tar and gravel / bitumen 18 = Thatched 19 = Tile Clay 20 = Tile Concrete 21 = Tile slate 22 = Wood shake/shingle 23 = Other 24 = Kliplock |
6/7/8/9/10/11/12/13/14/15/16/17 /18/19/20/21/22/23/24 |
| roof_type_adder_3_cost_per_panel | Cost per panel for roof type 3. | Number |
| roof_type_adder_3_cost_per_system | Cost per system for roof type 3. | Number |
| roof_type_adder_3_cost_per_watt | Cost per watt for roof type 3. | Number |
| roof_type_adder_3_roof_type |
Roof type 1 6 = Composition/Asphalt Shingle 7 = Flat Concrete 8 = Flat foam 9 = Membrane EPDM 10 = Membrane PVC 11 = Membrane TPO 12 = Metal Decramastic 13 = Metal Shingle 14 = Metal standing seam 15 = Metal stone coated 16 = Metal tin 17 = tar and gravel / bitumen 18 = Thatched 19 = Tile Clay 20 = Tile Concrete 21 = Tile slate 22 = Wood shake/shingle 23 = Other 24 = Kliplock |
6/7/8/9/10/11/12/13/14/15/16/17 /18/19/20/21/22/23/24 |
| roof_type_adder_4_cost_per_panel | Cost per panel for roof type 4. | Number |
| roof_type_adder_4_cost_per_system | Cost per system for roof type 4. | Number |
| roof_type_adder_4_cost_per_watt | Cost per watt for roof type 4. | Number |
| roof_type_adder_4_roof_type |
Roof type 1 6 = Composition/Asphalt Shingle 7 = Flat Concrete 8 = Flat foam 9 = Membrane EPDM 10 = Membrane PVC 11 = Membrane TPO 12 = Metal Decramastic 13 = Metal Shingle 14 = Metal standing seam 15 = Metal stone coated 16 = Metal tin 17 = tar and gravel / bitumen 18 = Thatched 19 = Tile Clay 20 = Tile Concrete 21 = Tile slate 22 = Wood shake/shingle 23 = Other 24 = Kliplock |
6/7/8/9/10/11/12/13/14/15/16/17 /18/19/20/21/22/23/24 |
| roof_type_adder_5_cost_per_panel | Cost per panel for roof type 5. | Number |
| roof_type_adder_5_cost_per_system | Cost per system for roof type 5. | Number |
| roof_type_adder_5_cost_per_watt | Cost per watt for roof type 5. | Number |
| roof_type_adder_5_roof_type |
Roof type 1 6 = Composition/Asphalt Shingle 7 = Flat Concrete 8 = Flat foam 9 = Membrane EPDM 10 = Membrane PVC 11 = Membrane TPO 12 = Metal Decramastic 13 = Metal Shingle 14 = Metal standing seam 15 = Metal stone coated 16 = Metal tin 17 = tar and gravel / bitumen 18 = Thatched 19 = Tile Clay 20 = Tile Concrete 21 = Tile slate 22 = Wood shake/shingle 23 = Other 24 = Kliplock |
6/7/8/9/10/11/12/13/14/15/16/17 /18/19/20/21/22/23/24 |
| steep_pitch_1_cost_per_panel | Costs for steep pitch 1 per panel. | Number |
| steep_pitch_1_cost_per_system | Costs for steep pitch 1 per system. | Number |
| steep_pitch_1_cost_per_watt | Costs for steep pitch 1 per watt. | Number |
| steep_pitch_1_slope | The slope at which steep pitch 1 costs are used. | Number |
| steep_pitch_2_cost_per_panel | Costs for steep pitch 2 per panel. | Number |
| steep_pitch_2_cost_per_system | Costs for steep pitch 2 per system. | Number |
| steep_pitch_2_cost_per_watt | Costs for steep pitch 2 per watt. | Number |
| steep_pitch_2_slope | The slope at which steep pitch 2 costs are used. | Number |
| steep_rack_1_cost_per_panel | Costs for steep rack 1 per panel. | Number |
| steep_rack_1_cost_per_system | Costs for steep rack 1 per system. | Number |
| steep_rack_1_cost_per_watt | Costs for steep rack 1 per watt. | Number |
| steep_rack_1_slope | The rack slope at which rack 1 costs are used. | Number |
| steep_rack_2_cost_per_panel | Costs for steep rack 2 per panel. | Number |
| steep_rack_2_cost_per_system | Costs for steep rack 2 per system. | Number |
| steep_rack_2_cost_per_watt | Costs for steep rack 2 per watt. | Number |
| steep_rack_2_slope | The rack slope at which rack 2 costs are used. | Number |
| steep_rack_3_cost_per_panel | Costs for steep rack 3 per panel. | Number |
| steep_rack_3_cost_per_system | Costs for steep rack 3 per system. | Number |
| steep_rack_3_cost_per_watt | Costs for steep rack 3 per watt. | Number |
| steep_rack_3_slope | The rack slope at which rack 3 costs are used. | Number |
| storeys_three_plus_cost_per_panel | The cost per panel for buildings that are 3+ storeys. | Number |
| storeys_three_plus_cost_per_system | The cost per system for buildings that are 3+ storeys. | Number |
| storeys_three_plus_cost_per_watt | The cost per watt for buildings that are 3+ storeys. | Number |
| storeys_two_cost_per_panel | The cost per panel for buildings that are 2 storeys. | Number |
| storeys_two_cost_per_system | The cost per system for buildings that are 2 storeys. | Number |
| storeys_two_cost_per_watt | The cost per watt for buildings that are 2 storeys. | Number |
| supplier_shipping_per_panel | The supplier shipping cost per panel. | Number |
| supplier_shipping_per_system | The supplier shipping cost per system. | Number |
| supplier_shipping_per_watt | The supplier shipping cost per watt. | Number |
| tilt_rack_cost_per_panel | The cost of tilt racks per panel. | Number |
| tilt_rack_cost_per_system | The cost of tilt racks per system. | Number |
| tilt_rack_cost_per_watt | The cost of tilt racks per watt. | Number |
Modules CSV format
| Value | Description | Input Format |
| code* Note that you cannot update this code through uploads. | The code of the module. | String |
| id | Leave it as you downloaded it in order to update an existing module. | Integer |
| cost | The cost of the module (ex tax). | Number |
| is_archived |
True = this module is archived False = this module is not archived. |
True/False |
| labor_adjustment | The labour cost of the module (ex tax). | Number |
| price_adjustment | The price adjustment per module (inc tax) | Number |
| price_adjustment_per_watt | The price adjustment per watt (inc tax). | Number |
| module_id | (Not really necessary to fill out) The OpenSolar database id for the module. | Integer |
| is_default |
True = apply this module as the default module False = do not apply this module as the default module.
Can only have one default module. |
True/False |
Inverters CSV format
| Value | Description | Input Format |
| code* Note that you cannot update this code through uploads. | The code of the inverter. | String |
| id | Leave it as you downloaded it in order to update an existing inverter. | Integer |
| cost | The cost of the inverter (ex tax). | Number |
| is_archived |
True = this inverter is archived False = this inverter is not archived. |
True/False |
| labor_adjustment | The labour cost of the inverter (ex tax). | Number |
| price_adjustment | The price adjustment per inverter (inc tax) | Number |
| price_adjustment_per_watt | The price adjustment per watt (inc tax). | Number |
| inverter_id | (Not really necessary to fill out) The OpenSolar database id for the inverter. | Integer |
| is_default |
True = apply this inverter as the default inverter False = do not apply this inverter as the default inverter. |
True/False |
| price_adjustment_per_panel | The price adjustment per panel (inc tax). | Number |
Batteries CSV format
| Value | Description | Input Format |
| code* Note that you cannot update this code through uploads. | The code of the battery. | String |
| id | Leave it as you downloaded it in order to update an existing battery. | Integer |
| cost | The cost of the battery (ex tax). | Number |
| is_archived |
True = this battery is archived False = this battery is not archived. |
True/False |
| labor_adjustment | The labour cost of the battery (ex tax). | Number |
| price_adjustment | The price adjustment per battery (inc tax) | Number |
| price_adjustment_per_watt | The price adjustment per watt (inc tax). | Number |
| battery_id | (Not really necessary to fill out) The OpenSolar database id for the battery. | Integer |
| price_adjustment_per_panel |
The price adjustment per panel (inc tax). |
Number |
Other Components CSV format
| Value | Description | Input Format |
| code* Note that you cannot update this code through uploads. | The code of the other component. | String |
| id | Leave it as you downloaded it in order to update an existing other component. | Integer |
| cost | The cost of the other component (ex tax). | Number |
| is_archived |
True = this other component is archived False = this other component is not archived. |
True/False |
| labor_adjustment | The labour cost of the other component (ex tax). | Number |
| price_adjustment | The price adjustment per other component (inc tax) | Number |
| price_adjustment_per_watt | The price adjustment per watt (inc tax). | Number |
| other_id | (Not really necessary to fill out) The OpenSolar database id for the other component. | Integer |
| price_adjustment_per_panel |
The price adjustment per panel (inc tax). |
Number |
Comments
0 comments
Article is closed for comments.