How to skip this error ” Not all of your products are available in the requested quantity.”

I am new in magento 2 and I have products in stock with qty 0, all of them. If I have an order when shipping of course this error showed up Not all of your products are available in the requested quantity. I need to edit each product’s qty to equal to the qty in the cart. where should I modify to do so?

Trying to do a time skip, but how do I justify it to my players?

I want to run a game in Eberron, but start it on the Day of Mourning (using the adventure in the back of the 4E book), then advance the time four years. However, as I want to use 5E, I want them to use what amounts to four years of downtime. I don’t feel it’s fair to take that away.

But here’s the problem: I know they’ll try to say that they continue adventuring, but that undercuts the point of the time skip. I want them to be able to do everything except explicitly adventure. How would I justify telling them they can’t?

I initially thought about saying that Khorvaire is too unstable for adventuring to be viable, but that feels flimsy. Are there other reasons I could use?

How to skip migrating certain entities in Drupal 8 Migration?

How do I skip migration for some entities? To simplify, let’s say I have a node type Cow with a field called field_moo. If field_moo is empty, I don’t want to migrate that nodes to the target. What can I put in my migration YAML to check if field_moo is empty, and if so, to skip the migration for that node?

Is there a source plugin that is similar to the process plugin skip_on_empty?

This is for a Drupal 7 to 8 migration.

How to skip blank columns in copy paste function?

I am incredibly new to VBA and have inefficiently coded a macro to save a lot of tedious effort but would like to make it more efficient. The code copies and pastes a range of cells to another sheet, re-calculates, copies the solution and pastes it. It then repeats this for the next column over (Row 2) and then so on until Row 15. The thing is often rows 8-14 are empty so it spends 5 minutes recalculating for no reason but Row 15 is always filled.

I was hoping for some help in identifying and skipping blank rows until Row 15.

I have tried googling other people’s codes which I can apply to my problem but haven’t found anything that works.

'Column 1 copySheet.Range("E8:E19").Copy pasteSheet.Range("H9:H20").PasteSpecial xlPasteValues Application.CutCopyMode = False Application.ScreenUpdating = True Set copySheet = Worksheets("Sensitivity") Set pasteSheet = Worksheets("Assays") Application.Calculate pasteSheet.Range("L90:L91").Copy copySheet.Range("E33:E34").PasteSpecial xlPasteValues Application.CutCopyMode = False Application.ScreenUpdating = True  'Column 2 copySheet.Range("F8:F19").Copy pasteSheet.Range("H9:H20").PasteSpecial xlPasteValues Application.CutCopyMode = False Application.ScreenUpdating = True Set copySheet = Worksheets("Sensitivity") Set pasteSheet = Worksheets("Assays") Application.Calculate pasteSheet.Range("L90:L91").Copy copySheet.Range("F33:F34").PasteSpecial xlPasteValues Application.CutCopyMode = False Application.ScreenUpdating = True  'Column 3 

etc

There is no actual error, it is just very inefficient. The sheet takes approx. 1 minute to re-calculate

Apps Script to skip files that have no blank rows

I created a script to delete blank rows from many spreadsheet files.

enter image description here the script I created like this:

function delRow(id, name, startRow, blankRow){   SpreadsheetApp.openById(id).getSheetByName(name).deleteRows(startRow, blankRow); }  function bulkDelRow(){   var spreadsheetID = [];    spreadsheetID = SpreadsheetApp.getActive()   .getRange('List!A2:F')   .getValues()   .reduce(function(p,c){     if (c[1] !== '' && c[2] !== '' && c[4] !== '' && c[5] !== '')       //p.push(SpreadsheetApp.openById(c[1]).getSheetByName(c[2]).deleteRows(c[4],c[5]));       p.push(!!delRow(c[1], c[2], c[4], c[5]));     return p;   }, []); } 

If one file does not have a blank row, the script will be error when run.

enter image description here

Skip words/vary word order in search for autocomplete suggestions

I’m using an Entity Reference field which searches taxonomy terms of type Person to suggest options for autocompletion.

Let’s say, i have the following terms (Persons): – Jason Jay Smith – John Jacob Andrews… etc.

When I input “Jason Ja…” in the field, the autocompletion works fine and suggests me the Smith guy. But if i input “Jason Smi…”, the term won’t be found because the word Jay is skipped. How can i fix this?

Or generally, how can i implement a better autocomplete search? My terms are composed of a number of words and searching by just one word or a fixed word order is definitely not enough

How to skip feed import for duplicate item in Drupal 7?

enter image description here

I use unique field mapping, but instead of blocking the import on duplicates from CSV, it overwrites the data in Drupal and inserts the new value from the CSV file.

This is the default behavior with unique title field mapping:

“IF the title is duplicate THEN overwrite old item in Drupal with new item from spreadsheet”

But I’m looking for this behaviour:

“IF the title is duplicate THEN skip new item from spreadsheet, and keep old original item in Drupal intact”

I have field tamper, the item field AND the importer field all set to unique. It all works fine, but on duplicate feed imports, instead of preventing import of duplicate items, it overwrites the old field, and inserts the new duplicate…

My goal is for Drupal to PREVENT the duplicate field to be populated at all…the same way if you manually try to input a duplicate entry in manually imputing content, it shows an error and prevents you from submitting the form.

Is this even possible without custom code? Maybe with rules?

Gmail’s label and skip the inbox filter

I am using Gmail. I want incoming mail that matches a label to skip the inbox. This does not seem to work. The instructions from Gmail include the following:

To keep organized, many people like to have incoming messages automatically labeled and removed from their inbox until they can look at them later at a more convenient time. If you want to do this, make sure to select Skip the Inbox (Archive it) and Apply the label: when you create your filter.

The filter looks like this:

Matches: from:(jean123@yahoo.com) Do this: Skip Inbox, Apply label “Jean123”, Never send it to Spam

However, such mail continues to appear in the inbox as well as All Mail. What am I doing wrong? (It also appears in a label for “Jean123” and I’m not sure how it got there but that is beside the point.)