View source for SPS

{{Module Introduction|{{PAGENAME}}|Integrations}} is an add-on module that can be installed from the {{Module|Plugin}}. After installing the plugin, a new module is added to Fishbowl that exchanges data with [https://www.spscommerce.com/ SPS Commerce] by connecting to a shared file server. Fishbowl customers and vendors can be mapped to SPS trading partners. Then the plugin can be scheduled to upload CSV files to the file server with the latest inventory quantities and purchase orders. The plugin can also download receiving data from the file server, allowing incoming orders to be pre-received in Fishbowl. The {{Module|SPS}} is completely separate from the [https://www.spscommerce.com/partner-community/fishbowl/fishbowl-partner-page/ SPS adapter for Fishbowl]. 
{{Plugin Install|{{PAGENAME}}|Integrations}}

=TABS=
==Trading Partners==
{{ImageTab|Trading Partners|{{PAGENAME}}}}

# In the {{Module|{{PAGENAME}}}}, enter the '''FTP URL''', '''Username''', and '''Password'''.
# Select '''Test''' or '''Production''' directories and then click the {{Button|Connect|Test Connection}} to verify that the connection is working.
# Use the {{Icon Button|Add}} to add trading partners.The SPS Trading Partner ID needs to be obtained directly from SPS.<br>[[File:SPS Add Trading Partners.png]]
# Click the {{Button|Save}} at the top of the module to save the settings.
# Trading partners that were added can now be selected on the other tabs shown below.

==Inventory==
{{ImageTab|Inventory|{{PAGENAME}}}}
[[File:SPS Add Inventory.png|right]]
# Click the {{Checkbox|Enable inventory exports|1}}.
# Click the {{Icon Button|Add}} and select a trading partner.
# Customize the inventory data that is sent to {{PAGENAME}} using the options below.
#* '''Export company wide inventory''' - Include inventory quantities from all location groups in the inventory sync. If this option is unchecked, selected location groups can be added by clicking the {{Icon Button|Add}}.
#* '''Inventory Type''' - Select the [[Inventory#Inventory_status_terms|inventory quantity]] that should be used during the update: '''Available For Sale''', '''Inventory On Hand''', or '''Available To Pick'''.
#* '''Product Tree filter''' - The export can be limited to certain product tree categories. If this field is left blank, all products will be included in the export.
#* '''Use max inventory quantity''' - With this option enabled, the maximum inventory quantity sent to {{PAGENAME}} can be limited. For example, if there is an available quantity of 4000 in Fishbowl, the quantity in {{PAGENAME}} could be set to 999.
#* '''Only send updated inventory items''' - Instead of exporting inventory quantities for all items every time, this option will only export the quantity if it has changed since the last export. 
#* '''Send Kit Quantities''' - {{KitQuantity|if '''Send Kit Quantities''' is checked,}}
#* '''SPS Options''' - This button allows the header and item fields that are sent to {{PAGENAME}} to be customized. You will need to consult with SPS on what data to fill out for this portion of the inventory feed.
# Click the {{Checkbox|Active|1}} in the '''Schedule''' section. Click the {{Icon Button|Run|Run Task}} to run the export now, or select a schedule frequency.
# Click '''Next''' to select another '''Trading Partner''' or click '''OK''' to close the dialog window.
# Click the {{Button|Save}} at the top of the module to save the settings.

<!-- Hiding these sections for now
==Purchase Orders==
{{ImageTab|Purchase Orders|{{PAGENAME}}}}
[[File:SPS Add Purchase Orders.png|right]]
# Click the {{Checkbox|Enable purchase order exports|1}}.
# Click the {{Icon Button|Add}} and select a trading partner that was [[#Trading Partners|added]] as a vendor.
# Click the {{Checkbox|Active|1}} in the '''Schedule''' section. Click the {{Icon Button|Run|Run Task}} to run the export now, or select a schedule frequency.
# Click '''Next''' to select another '''Trading Partner''' or click '''OK''' to close the dialog window.
# Click the {{Button|Save}} at the top of the module to save the settings.

==Receive Inventory==
{{ImageTab|Receive Inventory|{{PAGENAME}}}}

# Click the {{Checkbox|Enable receiving inventory data|1}}.
# Click the {{Icon Button|Add}} and select a trading partner.<br>[[File:SPS Add Receive Inventory.png|right]]
# Click the {{Checkbox|Active|1}} in the '''Schedule''' section. Click the {{Icon Button|Run|Run Task}} to run the import now, or select a schedule frequency.
# Click '''Next''' to select another '''Trading Partner''' or click '''OK''' to close the dialog window.
# Click the {{Button|Save}} at the top of the module to save the settings.

==Order Acknowledgment==
{{ImageTab|Order Acknowledgment|{{PAGENAME}}}}

# Click the {{Checkbox|Enable acknowledgments|1}}.
# Click the {{Icon Button|Add}} and select a trading partner.<br>[[File:SPS Add Order Acknowledgment.png|right]]
# Click the {{Checkbox|Active|1}} in the '''Schedule''' section. Click the {{Icon Button|Run|Run Task}} to run the import now, or select a schedule frequency.
# Click '''Next''' to select another '''Trading Partner''' or click '''OK''' to close the dialog window.
# Click the {{Button|Save}} at the top of the module to save the settings.
-->

==Invoice==
{{ImageTab|Invoice|{{PAGENAME}}}}

# Click the {{Checkbox|Enable invoices|1}}.
# Click the {{Icon Button|Add}} and select a trading partner.<br>[[File:SPS Add Invoice.png|right]]
# Click the {{Checkbox|Active|1}} in the '''Schedule''' section. Click the {{Icon Button|Run|Run Task}} to run the import now, or select a schedule frequency.
# Click '''Next''' to select another '''Trading Partner''' or click '''OK''' to close the dialog window.
# Click the {{Button|Save}} at the top of the module to save the settings.

{{Plugin Release Notes}}

{{HideH2|2020.8.X – 08-13-2020 - Fishbowl 2020.8}}
* Several fixes to csv files being pushed from Fishbowl to SPS (8/13)

{{HideH2|2020.5.X – 05-21-2020 - Fishbowl 2020.5}}
* Added new tasks for Invoice and Acknowledgements export tasks (5/21)
* Minor UI enhancements (5/21)