[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/Company-picture-6.webp” alt=”JX Truck Center” title_text=”Company picture 6″ _builder_version=”4.17.4″ _module_preset=”default” width=”100%” max_width=”600px” max_height=”360px” border_radii=”on|12px|12px|12px|12px” box_shadow_style=”preset1″ box_shadow_horizontal=”6px” box_shadow_vertical=”0px” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
JX Truck Center is a well-known transportation supplier working across 27 different locations and an expanding range of manufacturers.<\/p>\n
By using Sheetgo they can better manage inventory, provide real-time updates to field sales and save up to 12 hours a week on reporting, updates and data dissemination. This equates to a $22,000 annual saving.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Updating stock and sales level across 27 different locations <\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- Manual entry is time-consuming and requires each stock item to be updated 27 times (once for each location)<\/li>\n
- Data has to be readily accessible by sales agents in the field and updated automatically to drive decisions<\/li>\n
- The right location-based data needs to be efficiently delivered to each Regional Sales Representative in a standardized manner<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
JX Truck Center were using a combination of in-house spreadsheet solutions and manual entry in an attempt to provide real-time sales data to the field.<\/p>\n
The issue was that as their number of locations and product inventory grew, their 27 locations led to an exponential increase in time spent on this key task. Agents in the field were left working from outdated sales figures and no standardized approach was in place across regions.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]<\/p>\n
\u201c<\/span>The world runs on Excel (spreadsheets)!\u201d<\/b><\/p>\n
Joseph Yearous, Purchasing Manager, JX Truck Center<\/span><\/i><\/p>\n
[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
JX knew they needed a flexible and scalable solution capable of providing a standardized output that covered all locations, product lines and was broken up by region. They had worked to learn SQL in-house but had reached their ceiling in terms of resources and available time.<\/p>\n
They reached out to Sheetgo for a solution to their information dumping and increasing reliance on manual copy and pasting to move data between spreadsheets.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Automated inventory management using Sheetgo<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- Daily automations are used to move data between Google Sheets and Excel<\/li>\n
- Sheetgo consolidates raw data pulled from the in-house stock and sales systems<\/li>\n
- Data is broken up by region and sent to the relevant representative in the field<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
By using Sheetgo, JX can now perform daily automated migration of data that takes it from a raw output from their in-house systems, into a standardized and readily accessible set of sales figures. The data is segmented by region and automatically sent to the relevant representative in the field.<\/p>\n
This process impacts the working ability of up to 700 people and safely navigates 120 touch points along the way.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]<\/p>\n
\u201c<\/strong>Live help is extraordinary at Sheetgo, unbelievable.\u201d<\/b><\/p>\n
Joseph Yearous, Purchasing Manager, JX Truck Center<\/span><\/i><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Sheetgo allows JX to deliver up-to-date sales and stock figures to every representative in the field, allowing them to make smarter decisions and offer quicker turnaround times to customers.<\/p>\n
Efficiency is also improved in-house, with a single Purchasing Manager now saving up to 12 hours a week on manual entry and duplication of effort.<\/p>\n
[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Securing a $22K annual saving for smarter growth<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- $22,000 annual saving<\/li>\n
- Up-to-date sales and stock levels benefit up to 700 people<\/li>\n
- Information dumping via copy and paste is no longer needed<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
By delivering $22,000 in annual savings, JX\u2019s decision to use Sheetgo allows their Purchasing Manager to spend more time empowering the sales representatives to make data-driven decisions.<\/p>\n
Stock levels and sales targets are updated daily, ensuring the company can grow faster and more profitably in the future.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]<\/p>\n
\u201c<\/strong>I use Sheetgo because it saves me 10-12 hours of work per week.\u201d<\/b><\/p>\n
Joseph Yearous, Purchasing Manager, JX Truck Center <\/span><\/i><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
With help from Sheetgo, JX no longer has to devote 12 hours a week to manual entry and duplication of effort, only to still end up with outdated stock and sales data.<\/p>\n
They are currently planning on rolling out Sheetgo to otherer areas of their business \u2014 chiefly with a greater focus on sales \u2014 where they have already identified a monthly saving of 2-3 working days spent on adjusting pricing data.<\/p>\n
[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/Company-logo-3.webp” alt=”JX Truck Center logo” title_text=”Company logo (3)” align=”center” _builder_version=”4.17.4″ _module_preset=”default” width=”200px” max_width=”200px” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
JX Truck Center is a multi-site transportation company handling stock from a growing portfolio of suppliers across 27 different sites. They rely on fast, accurate and accessible data to deliver for their customers and clients.<\/span><\/p>\n
[\/et_pb_text][et_pb_icon font_icon=”||fa||900″ icon_width=”16px” align=”left” _builder_version=”4.16″ _module_preset=”default” custom_margin=”|20px|10px||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” width=”85%” custom_margin=”||10px||false|false” hover_enabled=”0″ custom_css_main_element=”display: inline-block;” global_colors_info=”{}” sticky_enabled=”0″]United States<\/span>[\/et_pb_text][et_pb_icon font_icon=”||fa||900″ icon_width=”16px” align=”left” _builder_version=”4.16″ _module_preset=”default” custom_margin=”|20px|||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” width=”85%” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]https:\/\/jxe.com\/<\/span><\/a>[\/et_pb_text][et_pb_divider _builder_version=”4.16″ _module_preset=”default” custom_margin=”||20px||false|false” global_colors_info=”{}”][\/et_pb_divider][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Industry<\/strong>
Transportation
<\/span><\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]Features used<\/strong><\/span><\/p>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-google-sheets.svg\")
Google Sheets<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/icon-excel.webp\")
Excel<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-merge.svg\")
Merge<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/icon-split.webp\")
Split<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/icon-filter.webp\")
Filter<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/append.webp\")
Append<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/icon-query.webp\")
SQL<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/network-view.webp\")
Network view<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/embed.webp\")
Embed<\/div>\n[\/et_pb_text][\/et_pb_column][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
JX Truck Center: Automated inventory management delivered by SheetgoSheetgo is the no-code spreadsheet automation platform that turns the data your team already keeps in Sheets, Excel, and CSVs into pipelines, dashboards, and AI-ready datasets.JX Truck Center is a well-known transportation supplier working across 27 different locations and an expanding range of manufacturers. By using Sheetgo […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":6600,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"difl_page_category":[],"class_list":["post-227619","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/227619","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=227619"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/227619\/revisions"}],"predecessor-version":[{"id":260766,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/227619\/revisions\/260766"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/6600"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=227619"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/difl_page_category?post=227619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}