Expandly: Help & Support

How can we help?

Logo1.png CSV Scheduler

Follow

Overview

The CSV scheduler feature allows you to automate manual processes and provide some extra functions. It requires either FTP or SFTP setup, to import or export CSV files into.

Some examples of how the CSV scheduler can be used are:

  • exporting sales orders into a custom warehouse system or third party to fulfil
  • import order tracking number information into Expandly, to update your sales channels
  • import stock levels on a daily, weekly or monthly frequency, to update the stock levels on Expandly and in turn your sales channels. 

In this guide, we will show you how to set up new schedulers and view, edit or delete existing schedulers on Expandly. 

Video

Setting up a new Scheduler

1. Click Settings (left menu) and then click CSV

mceclip0.png

2. Click mceclip1.png (top right)

3. On the Add CSV Scheduler page, within the Scheduler Details section, complete the following information:

Name - add the name you wish to be associated with the scheduler/job in Expandly

mceclip2.png

Type - this determines what happens when the job runs. Options available on the drop-down include:

mceclip3.png

  • Order Export - this will export sales orders into a CSV file. You can customise that data is exported via the Template Designer and using the filters on the CSV Order Template you create
  • Order Create - this is for importing new orders into Expandly. Orders will be created and available to view on your Sales Orders > Manage Sales Orders page
  • Order Update - this is for updating your sales order that are in Expandly (i.e. to add tracking numbers) 
  • Product Export - this will export your products into a CSV and is a good way of keeping a backup of your inventory, or pushing data into an external inventory or reporting system
  • Product Add/Update - this allow you to create new products in Expandly, or update existing one (i.e. you could use this to automatically import a stock file, which will update quantities on your products and push this information out to your sales channels & listings) 
  • Report Export - this will allow you to export reports that you have created on your Reporting > Manage Reports page

CSV Source - select the connection type - FTP or SFTP 

mceclip4.png

Connection - select the connection. If you have not added a connection before, click mceclip6.png, and on the New Connection popup, add your FTP or SFTP details, including; Hostname, Username, Password and Port Number. Click  mceclip8.png to save changes

mceclip5.png

 

mceclip7.png

Once you have selected a connection, click mceclip9.png. This will allow Expandly to connect to your web server and depending on the Type selected, you can choose the location you want your exports to go to/location and file if you are importing. Once done, click mceclip8.png

CSV_scheduler3.png

If Import type was selected, after you select the file and click 'Save', you will be required to carry out some mapping, so we know what the fields on the CSV relate to on Expandly. Click mceclip13.png and on the Mapping popup, map all required fields and click mceclip8.png

mceclip11.png

mceclip10.png

4. On the Add CSV Scheduler page, within the Scheduler Settings section, complete the following information:

Run - this will determine when the CSV Scheduler job is going to run. Select from the drop-down for it to run either hourly, Daily, Weekly or Monthly and complete the additional frequency information, which will differ depending on the option chosen: 

mceclip14.png

mceclip15.png

mceclip16.png

mceclip17.png

mceclip18.png

Timezone - select the timezone from the drop-down box

mceclip19.png

5. Click mceclip8.png (top right)

6. Congratulations! You have now set up the CSV Scheduler on Expandly. 

Viewing, editing and deleting a Scheduler

1. Click Settings (left menu) and then click CSV

2. Any Schedules already created, can be viewed on your CSV Scheduler page

3.Click the Edit mceclip20.png icon to make changes to existing schedules or click the delete mceclip21.pngicon to remove the schedule from Expandly. 

Need more help?

If you need a little extra help, no problem. Contact us, and we'll talk you through the steps

Contact Us

Was this article helpful?
0 out of 0 found this helpful

Comments