Print Adult Ordered with airSlate SignNow

Print adult ordered

one of the new features of the Apogee store from 2.0 what to print system is support for variable data processing using this VDP option print buyers can easily order batches of print products with each individual copy personalized in this video I want to show some examples of the use of that VDP option the first example I want to show is a poster for a chain of pet stores they need this poster with each time the address of the store inserted in this section of the layout what the print buyer can do is select how many copies he needs for each pet store and then upload an Excel data file with a list of all of the addresses that need to be inserted so let's do that and then we see the example of the first layout that Apogee storefront generated I can now select a layout that I want to see and use the navigation buttons to go through each individual personalized copy and check if it is correct to order this set of posters simply add it to the shopping cart give it a name and then it shows up in our cart where I see that I've ordered 24 records of 50 posters or a total of 1200 copies this store is configured not to display prices so I only get to see quantities let's order a second set of posters and this time it's a slight variation on the ones that I showed previously because for this poster you do not specify as a print buyer the quantities instead the quantities are defined in the excel file itself obviously the print buyer needs to know how those excel data need to be structured so there's an option in the store to download a template if we open the template in Excel you see that it contains two worksheets the first worksheet simply says which data need to be made available in this case it's the quantity the street postcode and city and each line in the Excel spreadsheet will become one new record when I order the second worksheet in this spreadsheet specifies in more detail the data that are needed so I see that all of the fields are mandatory and that four quantities I should order either 25 50 or 100 copies if I actually do that and click on the upload button select a file you see that I'm now using a demo file which has indeed the quantities specified when I order it's similar to the previous product I get to see my first poster can navigate through them and can still do last-minute Corrections so if it isn't Wellington Street but it's Wellington Avenue I can still go in here and do that last-minute correction navigate through all of them until I'm perfectly happy and then once again add this product to my card since the quantities are now variable you see that the cart also shows this it shows that there are 8 posters for which 25 copies will be printed four of them with 50 copies and 12 of them are larger pet stores that need more posters to advertise for park dog food so now we have 1600 posters that will be printed in this second store I want to show some additional examples of variable data products this business card product for instance allows a user to upload a spreadsheet that contains quantities and contact details what happens however if the customer accidentally uploads a spreadsheet that has some error in it let me show that to you by using this spreadsheet which does contain quantities and contact details but you see that in two rows the quantity is not specified if such an excel data sheet is uploaded the preflight engine of Apogee storefront will catch the error and inform the user that two errors were found to see where there is a problem the user can click this link over here that automatically opens the spreadsheet and the problem column as well as the fields where there is an issue are highlighted in bright red the preflight engine of Apogee storefront will not only validate if mandatory data are missing it can also validate data types so if a certain column needs to contain numbers the preflight engine will warn if somewhere text is used and it can also check boundaries so if quantities are allowed to be between 50 and 500 the preflight engine will warn if you ask a thousand copies of a certain business card what the user should now do is fix this spreadsheet and then upload a corrected one another potential problem is copy fitting I've already shown that you can navigate through all of the cards to see how text fits within the space that is foreseen there is however another option and that is the use of this filter which allows me to select a certain field and then ask for the longest value the shortest value or a specific value the longest street name in all of the business cards is card number 18 which contains this text obviously all of the copy fitting tools that are available in the online editor are also available for variable data products so you see that this card for instance it contains a phone number but if no phone number is available then automatically the text shifts if an address would contain multiple lines then you can configure the online editor to change the size of the type so that it can fit within this space and that is foreseen the last product that I want to show to you is a postcard it's this card over here which consists of a back that contains an address and an optional message and for the front of the card there is a choice of three different images switching between the available images is done in the spreadsheet by use of three columns that I can show here it's the last three columns in the spreadsheet where a yes indicates which particular image should be used so if we look at this card and scroll through some of the examples you see that the image alternates between various cards and that in some cases you have no message in other cases there is that optional message the 2.0 version of appaji storefront doesn't allow you yet to include images in the variable data alternating between these three images is done by adding three layers in the InDesign layout and then switching from one layer to another in fact when doing Corrections you can still do that manually and override the setting that came with the excel file so if I prefer to switch it to the Hawaii picture I can simply deactivate this picture and activate the other one when it comes to longer text such as this customized message over here you can also still do corrections so I could for instance that take the serious fun text and put some extra emphasis on it by putting that in bold when the print buyer makes such last-minute Corrections and is ready to order the product you see that the cartel allows you to also download an Excel spreadsheet but this time that excel file also includes all of the corrections that were applied in the online editor so this excel file might be the perfect basis in the future where there are reorders that need to be done and this concludes this demo of the variable data processing option for Apogee storefront as you have seen the video option allows you to offer additional services to your customers making it easier for them to order large quantities of print and obviously that also means more revenue for you